Re: INS/UPD/DEL RETURNING for 8.2

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: neilc(at)samurai(dot)com, jonah(dot)harris(at)gmail(dot)com
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: INS/UPD/DEL RETURNING for 8.2
Date: 2006-03-05 08:25:49
Message-ID: BAY20-F4F89076E252EDFEB05EF6F9E80@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

>
>I wonder if we should try to consistently treat an INSERT/UPDATE/DELETE
>with a RETURNING clause like a SELECT with an equivalent target list.
>For example, should it be possible to write:
>
>FOR x in DELETE FROM t1 WHERE ... RETURNING t1.x LOOP
> ...
>END LOOP;
>
>Or open a cursor for a data-modifying statement with a RETURNING clause,
>etc.
>
>-Neil

good idea
Pavel

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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2006-03-05 16:45:58 Re: implement prepared queries in plperl
Previous Message Bruce Momjian 2006-03-05 05:31:54 Re: Fix for /dev/tty on Win32