Re: PL/pgSQL proposal: using list of scalars in assign stmts, fore and fors stmts

From: David Fetter <david(at)fetter(dot)org>
To: Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PL/pgSQL proposal: using list of scalars in assign stmts, fore and fors stmts
Date: 2005-12-22 21:06:45
Message-ID: 20051222210645.GD9121@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Dec 22, 2005 at 10:18:16AM +0100, Pavel Stehule wrote:
> Hello
>
> Now, statements EXECUTE INTO and SELECT INTO allow using list of scalars.
> FORe and FORs allow only ROW o RECORD VARIABLE. I'll plan and I did it
> enhance this stmts:
>
> <for> := FOR <target> IN {SELECT | EXECUTE} ... LOOP
> <target> := {row|record|comma separated list of scalar vars}
>
> <assign> := <target2> ':=' <expression>
> <target2> := {row|record|variable|'ROW(' comma separated list of scalar
> vars ')'}

How about:

<target2> := {row|record|variable|'[ROW](' comma separated list of scalar vars ')'}

instead, where the ROW is optional?

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-12-22 21:10:54 Re: Automatic function replanning
Previous Message Lukas Smith 2005-12-22 20:55:14 Re: Automatic function replanning