Every once in a while, I have to write a big gnarly query like
where (%s) > 99
[a, a, b, b, c, c, a, a, b])
The point being that I have to repeat lots of parameters because I use
them in several where-clauses.
It would make these queries vastly easier to read and debug if I could
pass in bound variables as a dictionary, rather than as a tuple.
Is this possible?
W. Matthew Wilson
psycopg by date
|Next:||From: Adrian Klaver||Date: 2011-07-20 00:33:48|
|Subject: Re: I wish I could pass bound variables as a dictionary not a list|
|Previous:||From: Federico Di Gregorio||Date: 2011-07-05 08:35:36|
|Subject: Re: Named Cursors WITH HOLD|