Re: INS/UPD/DEL RETURNING for 8.2 - Mailing list pgsql-patches

From Pavel Stehule
Subject Re: INS/UPD/DEL RETURNING for 8.2
Date
Msg-id BAY20-F4F89076E252EDFEB05EF6F9E80@phx.gbl
Whole thread Raw
In response to Re: INS/UPD/DEL RETURNING for 8.2  (Neil Conway <neilc@samurai.com>)
List 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/


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fix for /dev/tty on Win32
Next
From: Andrew Dunstan
Date:
Subject: Re: implement prepared queries in plperl