money bug
jose' soares <sferac@bo.nettuno.it>
From: Sferacarta Software <sferac@bo.nettuno.it>
To: pgsql-hackers@postgresql.org
Date: 1999-01-04T14:14:30Z
Lists: pgsql-hackers
Hi all, I have this funny result when I tried to multiply a money by a float: select '($21,474,836.48)'::money / '1.0'::float8; ?column? ---------------- ($./,,),,(-*.,() (1 row) select '$21,474,836.47'::money * '2.0'::float8; ?column? ---------------- ($./,,),,(-*.,() (1 row) --If I use integer instead of float it gives me an expected overflow --result: select '$21,474,836.47'::money * '2'::int4; ?column? -------- ($0.02) (1 row) I'm using v6.4 on Linux. -Jose'-