Hi, I am a new sqlalchemy user. I'm a bit confused by the behavior of the Numeric data type. Consider the following code:
from sqlalchemy import * db = create_engine('sqlite:///test.db') metadata = MetaData() table = Table('thetable',metadata,Column('x',Numeric(scale=3)),Column ('y',Float)) metadata.create_all(db) a = 300.155555 c = db.connect() c.execute(table.insert(),{'x':a,'y':a}) c.close() Now inspecting the database: valinor:sqlalchemy tom$ sqlite3 test.db SQLite version 3.4.0 Enter ".help" for instructions sqlite> select * from thetable; 300.155555|300.155555 Should the first column not be 300.156 since I specified scale=3? Am I doing something wrong? Thanks for any help, Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@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 -~----------~----~----~----~------~----~------~--~---