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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly