Обсуждение: Locale settings

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.

Thanks for any help,
Janusz

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