| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Janusz Guzdzik <janusz(at)subtilia(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Locale settings |
| Date: | 2002-06-25 08:44:33 |
| Message-ID: | 20020625104433.A3614@zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | frbn | 2002-06-25 08:51:50 | Re: URGENT: Performance tuning |
| Previous Message | Marc G. Fournier | 2002-06-25 08:01:49 | Re: Proxy Server ... |