On May 17, 2013, at 12:33 PM, Christoph Zwerschke <c...@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? right, did you pass any parameters to execute()? I believe if no parameters are present, it decides not to do the "%" operation. Other DBAPIs that don't use format/pyformat don't have this behavior. _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
