The following bug has been logged online:

Bug reference: 2396
Logged by: Martin
Email address: SeaReports (AT) aol (DOT) com
PostgreSQL version: 8.1.3
Operating system: Win XP SP 2 German
Description: SELECT to_number('6500', '999,999.99') != 650
Details:

1.) I have found some mails from Nov 2004 concerning the same problem with
to_number, so is it sitll not solved or not a bug?

SELECT to_number('6500', '999,999,999.99'), to_number('6500',
'999999999.99'), to_number('6500', '999999.999,99'), to_number('6500',
'FM999,999.99');

=>

650 !! 6500 6500 6500

7.3.6 SuSe 8.0
8.1.3 Debian
8.1.3 Win XP

2.) I cant find this feature/bug in the doc's or in
postgresql-8.1.3\src\test\regress\sql\numeric.sql.
Is there a bug-list?

Thank you for your efforts!

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org