Re: decimal seperator

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