Postgres Pro
Downloads
Home   >   mailing lists

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

From Brendan Jurd
Subject Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)
Date
Msg-id 37ed240d0710161640h6a99f294q2ee93a7facba9722@mail.gmail.com
Whole thread Raw
In response to Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)
List pgsql-hackers
Tree view 
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.

Regards,
BJ

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.
Next
From: "Hiroshi Saito"
Date:
Subject: Re: [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.