Re: decimal seperator

On 1/4/2011 8:16 PM, Jasmin Dizdarevic 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?
>
> Regards,
> Jasmin
>
>
I am afraid that it can't be adjusted. You can use to_char and to_number
to get the desired format, but PostgreSQL only accepts the standard SQL
notation. I tried playing with setting LC_NUMERIC, but no luck. It
displays messages in the different format but nothing helps with the
numbers.

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