I've got a column defined as this: Column("cost", Numeric, nullable=False)
In Oracle, it seems I can't take advantage of the Decimal() class. I get rounding errors as if using float instead of Decimal, see output for Oracle vs. Postgres..... ************Oracle 8i (use_ansi=False): >>> itl.cost Decimal('8.99') >>> itl.cost = Decimal('5.99') >>> >>> DBSession.flush() 16:21:48,090 INFO [sqlalchemy.engine.base.Engine.0x...4c10] UPDATE inventorytransactions SET cost=:cost WHERE inventorytransactions.transactionid = :inventorytransactions_tr_1 16:21:48,090 INFO [sqlalchemy.engine.base.Engine.0x...4c10] {'inventorytransactions_tr_1': 'AAAFD2AAEAAACN/AAA', 'cost': 5.9900000000000002} >>> ************postgres: >>> DBSession.flush() 16:30:03,357 INFO [sqlalchemy.engine.base.Engine.0x...4ad0] UPDATE inventorytransactions SET cost=%(cost)s WHERE inventorytransactions.transactionid = % (inventorytransactions_transactionid)s 16:30:03,357 INFO [sqlalchemy.engine.base.Engine.0x...4ad0] {'cost': Decimal('5.99'), 'inventorytransactions_transactionid': 'A'} Am I doing something wrong? -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.