[Zope] ZSQL Method's Precision

Jason C. Leach jason.leach at gmail.com
Tue Oct 24 00:05:03 EDT 2006


Hi:

In a PostgreSQL DB I have a Numeric data type with a precision of two
decimal places. If I have 1.33 in as the result from my query, it's
everything is good. However, if I have 1.30 it reduces the precision
to one decimal place and I get 1.3. Not so good when dealing with
currency ( I don't want to use the money data dype ).

Any ideas on how I can get my ZSQL method to keep two decimal places?

Thanks,
Jason.


-- 
........................................
.... Jason C. Leach
.... PGP Key: 0x62DDDF75
.... Keyserver: gpg.mit.edu


More information about the Zope mailing list