> > How can to_number work with Danish locale? > It looks like you have "C" locale instead of Danish one. What happens when > you change your system locale to Danish?.
Seems to use the settings in postgresql.conf, NOT pg_settings. I don't know what they are used for. So it seems that PostgreSQL can handle one and only one locale setting per installation. Hmmm. -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 Åben 12.00-18.00 Email: [EMAIL PROTECTED] 2000 Frederiksberg Lørdag 12.00-16.00 Web: www.suse.dk ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly