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

Daniele Varrazzo 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.

-- Daniele

More information about the DB-SIG mailing list