Christian Jauvin 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,
Hi,
First, I already posted that question to SO, if you prefer to answer it there:
http://stackoverflow.com/questions/15882501/difference-between-python-and-postgres-locale-currency-formats
Using Python 2.6, I get:
import locale
locale.setlocale(locale.LC_MONETARY, 'fr_CA.UTF-8')
locale.currenc