I have a table that has a column of type money. A query such as "select
sum(document_amount) from foo" returns the correct result when executed
from psql, yet the same query returns the wrong answer (it appears to be
a rounding issue--something like "1234.9999999999...") when executed
through PygreSQL. Is there a workaround or a fix?
While browsing the mailing list for an answer to this problem I found
several references to the money type being deprecated. Is that the
problem?
This is PostgreSQL 7.1.3 on FreeBSD 4.2
TIA
--
Joel