Re: Server side prepared statements and executemany - Mailing list psycopg

From P. Christeas
Subject Re: Server side prepared statements and executemany
Date
Msg-id 201311161040.02676.xrg@linux.gr
Whole thread Raw
In response to Re: Server side prepared statements and executemany  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
List psycopg
On Friday 15 November 2013, Daniele Varrazzo wrote:
> On Fri, Nov 15, 2013 at 12:34 PM, Luca Ferroni <luca@befair.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.


psycopg by date:

Previous
From: jared
Date:
Subject: Re: Value substitutions with a dictionary.
Next
From: Victor Hooi
Date:
Subject: Using context managers for connections/cursors - cursors are closed, connections are not?