Skip site navigation (1) Skip section navigation (2)

Re: decimal seperator

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: decimal seperator
Date: 2011-01-05 01:39:23
Message-ID: 4D23CBCB.2000900@vmsinfo.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

pgsql-novice by date

Next:From: AndrejDate: 2011-01-05 01:39:34
Subject: Re: decimal seperator
Previous:From: Jasmin DizdarevicDate: 2011-01-05 01:16:54
Subject: decimal seperator

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group