Christian Jauvin <cjauvin@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
