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