From: | "Martin" <SeaReports(at)aol(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2396: SELECT to_number('6500', '999,999.99') != 650 |
Date: | 2006-04-14 06:47:45 |
Message-ID: | 200604140647.k3E6lj6T059929@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2006-04-14 09:51:44 | Re: BUG #2386: pg_restore doesn't restore large objects |
Previous Message | wangshj | 2006-04-14 06:30:10 | BUG #2395: Can't get right type oid by PQftype. |