Skip site navigation (1) Skip section navigation (2)

BUG #2396: SELECT to_number('6500', '999,999.99') != 650

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 (view raw or flat)
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!

pgsql-bugs by date

Next:From: Andreas PflugDate: 2006-04-14 09:51:44
Subject: Re: BUG #2386: pg_restore doesn't restore large objects
Previous:From: wangshjDate: 2006-04-14 06:30:10
Subject: BUG #2395: Can't get right type oid by PQftype.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group