Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the effect of locale on numbers? - Mailing list pgsql-general

From Tom Lane
Subject Re: What is the effect of locale on numbers?
Date
Msg-id 3029.1285082152@sss.pgh.pa.us
Whole thread Raw
In response to What is the effect of locale on numbers?  (A B <gentosaker@gmail.com>)
List pgsql-general
Tree view 
A B <gentosaker@gmail.com> writes:
> I use swedish locale

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

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

The regular output of numbers is intentionally not locale-aware.
You can use to_char() to obtain locale-specific formats.

            regards, tom lane

pgsql-general by date:

Previous
From: Henri De Feraudy
Date:
Subject: trying to use libpq in Ubuntu
Next
From: "Daniel Verite"
Date:
Subject: Re: trying to use libpq in Ubuntu