Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4) - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)
Date
Msg-id 162867790710171220g102ee0ai45c0b6719c182f68@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)  ("Brendan Jurd" <direvus@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: tsearch2api project
Next
From: "Pavel Stehule"
Date:
Subject: Re: tsearch2api project