Re: Server side prepared statements and executemany

Поиск
Список
Период
Сортировка
От P. Christeas
Тема Re: Server side prepared statements and executemany
Дата
Msg-id 201311161040.02676.xrg@linux.gr
обсуждение исходный текст
Ответ на Re: Server side prepared statements and executemany  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: jared
Дата:
Сообщение: Re: Value substitutions with a dictionary.
Следующее
От: Victor Hooi
Дата:
Сообщение: Using context managers for connections/cursors - cursors are closed, connections are not?