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?
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