From: Stéphane DEWITTE <stephane@smeso.fr>
To: pgsql-sql@postgresql.org
Subject: Help with conversions (suite)
Date: Wed, 17 Apr 2002 18:18:15 +0200
Message-ID: <NOEAIPGJHJIHECKNEIBGKEHGCOAA.stephane@smeso.fr> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: stephane@smeso.fr
Subject: Re: Help with conversions (suite)
In-Reply-To: <NOEAIPGJHJIHECKNEIBGKEHGCOAA.stephane@smeso.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox