Re: Python interface and Money?

"D'Arcy J.M. Cain" wrote:
>
> Thus spake Joel Mc Graw
> > 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?
>
> That sounds like a Python issue. The correct value is passed to the
> Python function as a string since it is always stored and delivered
> correctly in the database. That's sort of the point of the money type.
>
> I have been thinking of creating a money type in Python so that this
> won't happen but haven't got around to it yet. In the meantime you
> can always format it with "%.2f" to get the correct value displayed.

There are pure python BigDecimal and Money types available in the same
place as m2crypto:

http://www.post1.com/home/ngps/m2/

Last time I checked the license seemed to be compatible.

> > 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?
>
> They keep saying that DECIMAL should be used instead but they are not
> exactly equivalent. The MONEY type was originally written with locale
> support and displays the local currency symbol.

This of course will be a real PITA to parse reliably in the adapter ;(

--------------
Hannu