| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrej | 2011-01-05 01:39:34 | Re: decimal seperator |
| Previous Message | Jasmin Dizdarevic | 2011-01-05 01:16:54 | decimal seperator |