[DB-SIG] API 3.0 limiting paramstyle to ['named', 'qmark'] is okay. ('format' is not desirable)
daniele.varrazzo at gmail.com
Fri May 17 18:41:58 CEST 2013
On Fri, May 17, 2013 at 5:33 PM, Christoph Zwerschke <cito at online.de> wrote:
> 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?
You have tested it wrong, and haven't bothered reading the first few
lines of the first page of the documentation of the driver library.
More information about the DB-SIG