Difference between Python and Postgres locale currency formats - Mailing list pgsql-general

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.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