X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 530D4475921 for ; Sun, 30 Mar 2003 13:24:35 -0500 (EST) Received: from smtp220.tiscali.dk (smtp220.tiscali.dk [62.79.79.114]) by postgresql.org (Postfix) with ESMTP id 5E677474E5C for ; Sun, 30 Mar 2003 13:24:34 -0500 (EST) Received: from cpmail.dk.tiscali.com (mail.tiscali.dk [212.54.64.159]) by smtp220.tiscali.dk (8.12.6/8.12.6) with ESMTP id h2UIOE8R011807 for ; Sun, 30 Mar 2003 20:24:32 +0200 (CEST) (envelope-from kar@kakidata.dk) Received: from strider (213.237.10.83) by cpmail.dk.tiscali.com (6.0.053) id 3E4A9909005A4434 for pgsql-sql@postgresql.org; Sun, 30 Mar 2003 20:24:32 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Kaare Rasmussen Reply-To: kar@kakidata.dk To: pgsql-sql@postgresql.org Subject: Re: to_number Date: Sun, 30 Mar 2003 19:24:38 +0200 User-Agent: KMail/1.4.3 References: <200303301454.30758.kar@kakidata.dk> <20030330155626.M93108@klaster.net> In-Reply-To: <20030330155626.M93108@klaster.net> MIME-Version: 1.0 Message-Id: <200303301924.38592.kar@kakidata.dk> Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-22.5 required=5.0 tests=BAYES_10,IN_REP_TO,QUOTE_TWICE_1,REFERENCES, USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/646 X-Sequence-Number: 12684 > > 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= =20 what they are used for. So it seems that PostgreSQL can handle one and only one locale setting per= =20 installation. Hmmm. --=20 Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 =C5ben 12.00-18.00 Email: kar@kakidata.dk 2000 Frederiksberg L=F8rdag 12.00-16.00 Web: www.suse.dk