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