Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm - Mailing list pgsql-patches

From Pavel Stehule
Subject Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm
Date
Msg-id BAY20-F2301EBABA30700C408681EF93E0@phx.gbl
Whole thread Raw
In response to Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stms  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
>
>"Pavel Stehule" <pavel.stehule@hotmail.com> writes:
> >     x, y := r;
>
>That strikes me as a really bad idea.  It weakens both syntax and
>semantic error checking, to accomplish how much?
>

It's same as select into or execute into (using same code). And behave is
like row variable := row variable. I am not sure if it's good idea. But it's
can be usefull when you have out variables and you have to fill them. There
are not control for count of arguments, but types are checked.

I can understand so this topic is little bit controvers. And maybe we don't
need this statements, if we have this possibility in fore and fors stmts.

Regards
Pavel Stehule

_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/


pgsql-patches by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: COPY LOCK for WAL bypass
Next
From: "Pavel Stehule"
Date:
Subject: Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm