On Oct 23, 2011, at 2:11 PM, Krishnakant Mane wrote: > > I wish to know if None in Python really gets converted to null in postgresql?
it is converted to NULL by psycopg2 if passed as a bound parameter to cursor.execute(). To understand what this means at a DBAPI level please read http://initd.org/psycopg/docs/usage.html#query-parameters . this query: > engine.execute("select * from setAccount('grp001','account_name',None") does not use bound parameters. A SQLAlchemy call that will use psycopg2's bound parameter services looks like: engine.execute("select * from setAccount(%(a)s, %(b)s, %(c)s)", {"a":"group1", "b":"account_name", "c":None}) -- 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.
