X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9F6544758E6 for ; Sun, 30 Mar 2003 08:56:24 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id D0BF547580B for ; Sun, 30 Mar 2003 08:56:23 -0500 (EST) Received: from lamer.pl (localhost [127.0.0.1]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 872F36A26D; Sun, 30 Mar 2003 15:56:26 +0200 (CEST) From: "Tomasz Myrta" To: kar@kakidata.dk, Subject: Re: to_number Date: Sun, 30 Mar 2003 15:56:26 +0900 Message-Id: <20030330155626.M93108@klaster.net> In-Reply-To: <200303301454.30758.kar@kakidata.dk> References: <200303301454.30758.kar@kakidata.dk> X-Mailer: Open WebMail 1.62 20020221 X-OriginatingIP: 217.96.97.171 (jasiek) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 X-Spam-Status: No, hits=-25.9 required=5.0 tests=BAYES_01,DATE_IN_PAST_06_12,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES 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/645 X-Sequence-Number: 12683 > # 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 = > '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? It looks like you have "C" locale instead of Danish one. What happens when you change your system locale to Danish?. Regards, Tomasz Myrta