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

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@fetter.org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!