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

Re: decimal seperator

From: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>
To: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: decimal seperator
Date: 2011-01-05 01:46:16
Message-ID: AANLkTimWkdmnQepco7rS6Ge99mW04KV6br+NEaMFT-jY@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
++
That's the problem. I've also played around with it, without luck.

How other rdbms does handle this?

2011/1/5 Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>

> On 1/4/2011 8:39 PM, Andrej wrote:
>
>> On 5 January 2011 14:16, Jasmin Dizdarevic<jasmin(dot)dizdarevic(at)gmail(dot)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
>
>

In response to

Responses

pgsql-novice by date

Next:From: Mladen GogalaDate: 2011-01-05 02:05:03
Subject: Re: decimal seperator
Previous:From: Mladen GogalaDate: 2011-01-05 01:44:27
Subject: Re: decimal seperator

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