Skip site navigation (1) Skip section navigation (2)

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

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-patches(at)postgresql(dot)org, neilc(at)samurai(dot)com
Subject: Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stm
Date: 2005-12-20 21:37:26
Message-ID: BAY20-F2301EBABA30700C408681EF93E0@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
>"Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)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.

Pavel Stehule

Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.

In response to

pgsql-patches by date

Next:From: Hans-Jürgen SchönigDate: 2005-12-20 21:40:52
Subject: status of concurrent VACUUM patch ...
Previous:From: Jim C. NasbyDate: 2005-12-20 18:47:27
Subject: Re: COPY LOCK for WAL bypass

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group