Python interface and Money? - Mailing list pgsql-interfaces

From Joel Mc Graw
Subject Python interface and Money?
Date
Msg-id 3BD45B33.C217E6FF@databill.com
Whole thread Raw
Responses Re: Python interface and Money?  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: "Christopher C. Weis"
Date:
Subject: Re: Need help adding perl interface to 7.1.3 on MacOSX 10.1
Next
From: Tushar Nerurkar
Date:
Subject: pgadmin for postgresql 7.0