X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8D9F34758E6 for ; Sun, 30 Mar 2003 07:54:24 -0500 (EST) Received: from smtp020.tiscali.dk (smtp020.tiscali.dk [212.54.64.104]) by postgresql.org (Postfix) with ESMTP id 42C9A47580B for ; Sun, 30 Mar 2003 07:54:23 -0500 (EST) Received: from cpmail.dk.tiscali.com (mail.tiscali.dk [212.54.64.159]) by smtp020.tiscali.dk (8.12.5/8.12.5) with ESMTP id h2UCsN3D010850 for ; Sun, 30 Mar 2003 14:54:23 +0200 (MEST) Received: from strider (213.237.10.83) by cpmail.dk.tiscali.com (6.0.053) id 3E4A93E80059BFF3 for pgsql-sql@postgresql.org; Sun, 30 Mar 2003 14:54:13 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Kaare Rasmussen Reply-To: kar@kakidata.dk To: Subject: to_number Date: Sun, 30 Mar 2003 14:54:29 +0200 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Message-Id: <200303301454.30758.kar@kakidata.dk> Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-8.0 required=5.0 tests=BAYES_30,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/644 X-Sequence-Number: 12682 # SELECT * FROM pg_settings WHERE name LIKE 'lc_%'; name | setting -------------+--------- lc_messages | unset lc_monetary | C lc_numeric | C lc_time | C (4 rows SELECT price, to_number(price,'9999D9)') FROM orderline WHERE sku =3D=20 '01-0082-4'; price | to_number -------+----------- 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 429,5 | 4295 (10 rows) How can to_number work with Danish locale? --=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