Fix assorted bogosities in cash_in() and cash_out().

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 50939443118613d3ae072d900c1e97f64722e07c
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2011-10-29T18:31:03Z
Releases: 9.0.6
Fix assorted bogosities in cash_in() and cash_out().

cash_out failed to handle multiple-byte thousands separators, as per bug
#6277 from Alexander Law.  In addition, cash_in didn't handle that either,
nor could it handle multiple-byte positive_sign.  Both routines failed to
support multiple-byte mon_decimal_point, which I did not think was worth
changing, but at least now they check for the possibility and fall back to
using '.' rather than emitting invalid output.  Also, make cash_in handle
trailing negative signs, which formerly it would reject.  Since cash_out
generates trailing negative signs whenever the locale tells it to, this
last omission represents a fail-to-reload-dumped-data bug.  IMO that
justifies patching this all the way back.

Files

PathChange+/−
src/backend/utils/adt/cash.c modified +109 −95