Re: [SQL] Changing point for commas and commas for point

2007-01-21 Thread Andreas Kretschmer
Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> schrieb: > Hi list, > > 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), '0D00') > > Is there any way to make this happens ? I t

Re: [SQL] Changing point for commas and commas for point

2007-01-21 Thread Tom Lane
"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), '0D00') That's the right thing. > Is there any way to make this happens

[SQL] Changing point for commas and commas for point

2007-01-21 Thread Ezequias Rodrigues da Rocha
Hi list, 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), '0D00') Is there any way to make this happens ? Regards -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=