>
> http://pybrary.net/pg8000/dbapi.html
>
> You can pass parametric arguments but you cannot change the style these
> arguments are referred to in the SQL. Yet this is probably not too
> important.
>
The deal with those drivers that support the specs is that you do not
need to care about python <-> RDBMS type conversion.
For instance
i = 18
c.execute("select * from users where age > %(i)s", {"i": i}) -> SELECT
* FROM USERS WHERE AGE > 18;
nick = 'mic'
c.execute("select * from users where nick =%(nick)s", {"nick": nick})
-> SELECT * FROM USERS WHERE nick='mic' > 18;
So quoting of in and string are done properly as you can see that in
the execute() call no single quote needs to be put in place.
This is a simplistic example in real complex queries type conversion
becomes handy.
mic
--
