Re: [GENERAL] Difference between Python and Postgres locale currency formats

2013-04-08 Thread Tom Lane
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,

[GENERAL] Difference between Python and Postgres locale currency formats

2013-04-08 Thread Christian Jauvin
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