The following bug has been logged online: Bug reference: 2396 Logged by: Martin Email address: [EMAIL PROTECTED] 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