Re: Bug with locale (decimale/group seperator in numbers) - Mailing list pgsql-bugs

Hannes Wenzel <h.wenzel@aon.at> writes:
> A select with a to_char function to convert number to formated output with
> locale support produces wrong group seperator characters.

I think this must be a bug in the definition of that particular locale
on your system.  I get reasonable-looking behavior here:

regression=# select to_char(1719000.00000,'999G999G990D00');
     to_char
-----------------
    1,719,000.00
(1 row)

regression=# set lc_numeric TO 'de_DE.iso885915@euro';
SET
regression=# select to_char(1719000.00000,'999G999G990D00');
     to_char
-----------------
    1.719.000,00
(1 row)


            regards, tom lane