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

Christian Jauvin <cjauvin@gmail.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