Re: Locale settings - Mailing list pgsql-general

From Karel Zak
Subject Re: Locale settings
Date
Msg-id 20020625104433.A3614@zf.jcu.cz
Whole thread Raw
In response to Locale settings  (janusz@subtilia.net (Janusz Guzdzik))
List pgsql-general
On Fri, Jun 21, 2002 at 09:58:46AM -0700, Janusz Guzdzik wrote:
> Hi,
> I've problems with the european (comma as decimal separator) number
> format in Postgresql 7.2.1 database on FreeBSD4.6.
> I built postgreSQL with "--enable-locale", I setup system locales and
> re-initdb.
> My date/time and monetary format are as wanted, but the numbers
> (numeric, float) still require '.' (dot) as decimal separator.

 The locale setting has not effect to standard numbers formatting in
 PostgreSQL. You can use to_char() function (see docs).

    Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz



pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Proxy Server ...
Next
From: frbn
Date:
Subject: Re: URGENT: Performance tuning