Re: proposal for 8.3: Simultaneous assignment for PL/pgSQL

>Tom Lane wrote:
> > "Pavel Stehule" <pavel.stehule@hotmail.com> writes:
> >> a,b,c := out3fce(1); -- Simultaneous assignment
> >
> > I thought we rejected that idea once already, on the grounds that it
> > would make it too hard to tell the difference between intended code
> > and typos.
> >
>
>In any case, I had some questions:
>
>. is it compatible with PLSQL?
>. can the effect be achieved by assigning to a composite?

I looked into SQL2003, and SQL2003 knows it (SQL/PSM):

<assignment statement> ::=   <singleton variable assignment> | <multiple variable assignment>
<multiple variable assignment> ::=   SET <assignment target list> <equals operator> <assigned row>
<assignment target list> ::=   <left paren> <assignment target> [ { <comma> <assignment target> }... ] 
<right paren>
<singleton variable assignment> ::=   SET <assignment target> <equals operator> <assignment source>

Regards
Pavel Stehule

_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. 
http://www.msn.cz/