Received: from apache.smeso.fr (unknown [212.234.3.50]) by postgresql.org (Postfix) with ESMTP id B60EC4761B3 for ; Wed, 17 Apr 2002 12:18:46 -0400 (EDT) Received: from STEPHFIXE (ocp.smeso.fr [192.168.168.35]) by apache.smeso.fr (8.9.3/8.9.3) with SMTP id SAA30281 for ; Wed, 17 Apr 2002 18:18:51 +0200 From: =?iso-8859-1?Q?St=E9phane_DEWITTE?= To: Subject: Help with conversions (suite) Date: Wed, 17 Apr 2002 18:18:15 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200204/215 X-Sequence-Number: 7479 Hello everybody. I have a little problem. Where I make a select to_number('123456.789','000000.00') or select to_number('123456.789','000000D00') I obtain 123456.78 When I try to make that in a function, I have a varchar in ligne.temp8 (ex: '123456.78910') temp_dr_cli_cod := to_number(ligne.temp8,''000000000''); That is good (without decimals of course), but when I try to add a dot or a 'D' in the format field (ex : temp_dr_cli_cod := to_number(ligne.temp8,''000000.000'') or temp_dr_cli_cod := to_number(ligne.temp8,''000000D000'') I get a error message : ERROR: parser: parse error at or near "000000". Can someone help me ? Thanks a lot. Regards, Stéphane.