Re: Difference between Python and Postgres locale currency formats

Christian Jauvin <cjauvin(at)gmail(dot)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