Re: decimal seperator

On 1/4/2011 8:39 PM, Andrej wrote:

On 5 January 2011 14:16, Jasmin Dizdarevic<jasmin.dizdarevic@gmail.com>  wrote:

Hi,
is there a way to change the way how postgresql outputs floating point
numbers?
For example:
Instead of 2.34 =>  2,34 or
Instead of 334,323.53 =>  334.323,53
Can this be adjusted per session?

Does this help?
http://www.postgresql.org/docs/current/interactive/runtime-config-client.html#GUC-LC-NUMERIC

Not really:

mgogala=# set lc_numeric='de_DE';
SET
mgogala=# select 1/5::float;
 ?column?
----------
     0.2
(1 row)

mgogala=#


As you can see, I did set lc_numeric to the locale which uses decimal comma, not the decimal point and got back a point. I would have to do that with to_char function.

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com