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'-



Mon, 4 Jan 1999 15:14:30 +0100
Sferacarta Software <sferac@bo.nettuno.it>
money bug