Re: decimal point - european format

carex wrote:
> Hello,
>
> I am from Belgium (Europe) and this is my problem with postgres:
>
> SET DATESTYLE TO 'ISO';
>
> Ok, that's what I want for the date (2001-04-29)
> but the format for the floating point number is not correct.
>
> 1.05 should be 1,05
>
> How do I solve this ???

You need to set your locale; presumably it would be something like
fr_BE (if you're a French speaker - I don't know what it is for Flemish).
Locale needs to be set for both backend and frontend.

export LANG=fr_BE

(obviously you need locale support in your operating system and C library)

Warning: locales affect the sort order of indexes, so you need to
set locale before you run initdb. If you already have, dump, set locale,
initdb and reload.

In 7.1, you can use contrib/pg_controldata to see what the backend's
locale is, and the locale cannot be changed except by destroying the
database and running initdb again. In 7.0, the locale had to be set
each time the postmaster was started.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Live in harmony with one another. Do not be proud, but
be willing to associate with people of low position.
Do not be conceited." Romans 12:16