Difference between Python and Postgres locale currency formats

[Christian Jauvin <cjauvin@xxxxxxxxx>]

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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general