money types, decimal module

Timothy Smith <timothy-/[email protected]> Wed, 17 Nov 2004 12:52:30 +1000
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
hello i'm stuck with a problem. whats the best way to store money types. 
i know postgre has it's own money data type, but the problem is pythons 
decminal module. floats obviously aren't arrcurate enough, but when i 
use the decminal modle i get this error.

libpq.OperationalError: ERROR:  syntax error at or near ""11.00"" at 
character 88

obviously it's double quotes which are the problem. i'm just stumped 
where to go from here. surely other people have run into the exact same 
problem?


-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8