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

From: "Brendan Jurd" <direvus(at)gmail(dot)com>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)
Date: 2007-10-16 23:40:18
Message-ID: 37ed240d0710161640h6a99f294q2ee93a7facba9722@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/17/07, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Saito 2007-10-16 23:56:38 Re: [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.
Previous Message Tom Lane 2007-10-16 21:07:18 Re: [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.