Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)
Дата
Msg-id 162867790710171220g102ee0ai45c0b6719c182f68@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)  ("Brendan Jurd" <direvus@gmail.com>)
Список pgsql-hackers
2007/10/17, Brendan Jurd <direvus@gmail.com>:
> On 10/17/07, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> > New syntax:
> >
> > a) EXECUTE stringexpr
> >       [INTO [STRICT] varlist
> >       [USING exprlist]
> >
> > b) FOR varlist IN EXECUTE stringexpr USING exprlist LOOP ....
>
> Just chiming in with a +1.  I would find this feature very useful.
> Substitution of parameters is way more elegant than quoting, and the
> syntax looks nice.
>

I am doing some simple speed tests, and with USING run dynamic queries
little bit  faster (15%). Prepared statement accepts params in binary
form, so we don't need call out functions.

Pavel


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: tsearch2api project
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: tsearch2api project