Re: Server side prepared statements and executemany

On Friday 15 November 2013, Daniele Varrazzo wrote:
> On Fri, Nov 15, 2013 at 12:34 PM, Luca Ferroni <luca(at)befair(dot)it> wrote:
> > ...
> > but they raise ProgrammingError (syntaxerror SQL) with the operator IN
> > prepare psyco_1 as SELECT * FROM "prova" WHERE "name" IN $1
>
> I suspect the () of IN are a syntactic feature and cannot be passed as
> a parameter.
>

Indeed it is. It contains distinct parameters (as far as pq_execparams is
concerned).

--
Disclaimer waiver: When you send me an unencrypted email, you implicitly
allow me, or any 3rd person reading our mails, to do anything I/they wish
with your data (including presenting them in public). Your disclaimer, thus,
is void. If you had wanted a private communication, you should have used
encryption in the first place.