Re: [Pypgsql-users] quoting - bug ?

[<gh...@gh...>]

Karsten Hilbert wrote:
> Dear all,
> 
> suppose I want to find occurrences of "test" in a column
> "data" in a table "testtable". SQL would be:
> 
> select * from testtable where data='test';
> 
> Rewriting that for use with pyPgSQL:
> 
> query = "select * from testtable where data=%s;"
> arg = "test"
> curs.execute(query, arg)
> 
> Right ? [...]

No. It's probably entirely unrelated to your problem and just one of my 
favourite nitpicks, but the semicolon is a statement *separator*, not an 
end-of-statement character. The Python DB-API only allows to send one 
statement per .execute() call, so don't use the semicolon when using the 
DB-API.

-- Gerhard