Postgres Pro
Downloads
Home   >   mailing lists

Re: select to_number('1,000', '999,999'); - Mailing list pgsql-bugs

From Tom Lane
Subject Re: select to_number('1,000', '999,999');
Date
Msg-id 1926.1101085808@sss.pgh.pa.us
Whole thread Raw
In response to select to_number('1,000', '999,999');  (David Schweikert <dws@ee.ethz.ch>)
Responses Re: select to_number('1,000', '999,999');
List pgsql-bugs
Tree view 
David Schweikert <dws@ee.ethz.ch> writes:
> select to_number('1,000', '999,999') returns '100'.

I'm not entirely convinced this is a bug.  I get the right answer from

regression=# select to_number('001,000', '999,999') ;
 to_number
-----------
      1000
(1 row)

It's arguable that to_number() should throw an error when the input
doesn't match the format, but right now it doesn't ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: David Schweikert
Date:
Subject: select to_number('1,000', '999,999');
Next
From: David Schweikert
Date:
Subject: Re: select to_number('1,000', '999,999');