Difference between Python and Postgres locale currency formats
Hi,
First, I already posted that question to SO, if you prefer to answer it there:
Using Python 2.6, I get:
import locale
locale.setlocale(locale.LC_MONETARY, 'fr_CA.UTF-8')
locale.currency(1.234) # '1,23 $'
while using Postgres 9.1:
set lc_monetary = 'fr_CA.UTF-8';
select 1.234::money; -- '$1,23'
I think the Python version is the right one (not 100% sure though),
but how can they possibly be different?
Thanks,
Christian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Christian Jauvin <cjauvin@gmail.com> writes:
while using Postgres 9.1:
set lc_monetary = 'fr_CA.UTF-8';
select 1.234::money; -- '$1,23'
That was changed in 9.2 --- per the release notes:
Support more locale-specific formatting options for the money
data type (Tom Lane)
Specifically, honor all the POSIX options for ordering of the
value, sign, and currency symbol in monetary output. Also, make
sure that the thousands separator is only inserted to the left
of the decimal point, as required by POSIX.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general