Re: Executing prepared statements via bind params

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Executing prepared statements via bind params
Дата
Msg-id 26496.1308259181@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Executing prepared statements via bind params  (Peter Bex <Peter.Bex@xs4all.nl>)
Ответы Re: Executing prepared statements via bind params  (Peter Bex <Peter.Bex@xs4all.nl>)
Список pgsql-general
Peter Bex <Peter.Bex@xs4all.nl> writes:
> But when I try to do the same but pas the 2 as a parameter,
> (I do "EXECUTE bar($1)" with $1 bound to "2"), I get an error:

Why would you do that, rather than executing the prepared statement
directly with PQexecPrepared?  Interposing an EXECUTE doesn't do
anything but add parsing overhead.

The reason this particular case doesn't work is that utility statements
(including EXECUTE) don't have any support for $n parameters.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: PostgreSQL 8.4.8 bringing my website down every evening
Следующее
От: Peter Bex
Дата:
Сообщение: Re: Executing prepared statements via bind params