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

[Daniele Varrazzo]

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