"Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
