[DB-SIG] API 3.0 limiting paramstyle to ['named', 'qmark'] is okay. ('format' is not desirable)

Christoph Zwerschke cito at online.de
Fri May 17 18:33:17 CEST 2013


Am 17.05.2013 18:21, schrieb Daniele Varrazzo:
 > Quite the contrary: the quotes should never appear in the query and
 > these examples are correct but...

Just tested this with psycopg2. If you use the clause "WHERE name=%s" 
and pass a value without quotes, you get a ProgrammingError from the 
database. So is psycopg2 not properly implementing DBAPI 2?

-- Christoph




More information about the DB-SIG mailing list