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