--
-1.4210854715202e-14
(1 row)
amount is defined as double precision. I noticed that if I cast amount
as numeric, the sum comes out 0 as expected.
I am using postgresql 8.0.1
Thanks in advance for any help or suggestions.
Andrew Baerg
---(end of broadcast
Thanks for so many prompt responses. I have researched the differences
between floating point and arbitrary precision numbers in the pgsql
docs and understand now what is happening.
Thanks again to the many great members of the pgsql community.
Andrew
On 8/29/06, Andrew Baerg <[EMAIL PROTEC
