problem with money datatype based calculations in python

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


On Sat, 02 May 2009 15:43:23 +0200
"Günther Dietrich" <guenther.dietrich at spamfence.net> wrote:
> Krishnakant <krmane at gmail.com> 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 (http://www.PyGreSQL.org/) to connect to
the database then the money type is already converted to Decimal.

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



More information about the Python-list mailing list