What is the effect of locale on numbers?

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What is the effect of locale on numbers?
Date: 2010-09-21 09:42:41
Message-ID: AANLkTikC3TNq56f633hwLQVfC2hQES7WcWtto4uRVy0-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

I use swedish locale

show lc_numeric;
lc_numeric
-------------
sv_SE.UTF-8

and I get a . (dot) in all floating-point numbers.

This makes me wonder, when can I see the effects of the locale? That is, I get

select 355/113.0 as pie;
pie
--------------------
3,1415929203539823 <--- notice , instead of .

instead of

3.1415929203539823

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2010-09-21 10:05:22 Re: varchar lengths
Previous Message Marcus Engene 2010-09-21 09:40:51 varchar lengths