problem with money datatype based calculations in python

D'Arcy J.M. Cain darcy at
Sat May 2 17:57:34 CEST 2009

On Sat, 02 May 2009 15:43:23 +0200
"Günther Dietrich" <guenther.dietrich at> wrote:
> Krishnakant <krmane at> wrote:
> ['money datatype' for database stored values]
> What ist the real problem? Do you have problems converting results of 
> float calculations to the 'money datatype' before storing them in the 
> database, or do you want to avoid the precision issues which come with 
> the conversion od non-integer values between binary and decimal?
> In the latter case use the Decimal data type from module decimal (comes 
> with the python distribution -- it is mentioned in the tutorial).

And if you use PyGreSQL ( to connect to
the database then the money type is already converted to Decimal.

D'Arcy J.M. Cain <darcy at>         |  Democracy is three wolves                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.

More information about the Python-list mailing list