Re: Changing point for commas and commas for point

"Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> writes:
> Here in my country (Brazil) we have the decimal simbol as ' , ' (commas) and
> thousand separator as ' . ' (point)

> Here my sql uses: to_char(sum(My_column), '99990D00')

That's the right thing.

> Is there any way to make this happens ?

I think you forgot to set LC_NUMERIC.

regression=# select to_char(42.45, '99990D00');
to_char
-----------
42.45
(1 row)

regression=# set lc_numeric TO 'pt_PT.iso88591';
SET
regression=# select to_char(42.45, '99990D00');
to_char
-----------
42,45
(1 row)

The specific locale names available vary across OSes ... try "locale -a"
for a list.

regards, tom lane