Re: API 3.0 limiting paramstyle to ['named', 'qmark'] is okay. ('format' is not desirable)

Christoph Zwerschke <[email protected]>
Newsgroups gmane.comp.python.db
Message-ID <[email protected]>
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


_______________________________________________
DB-SIG maillist  -  [email protected]
http://mail.python.org/mailman/listinfo/db-sig
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.