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

On Thu, 2006-03-02 at 17:51 -0500, Jonah H. Harris wrote:
> Patch for core and PL/pgSQL to support the INSERT/UPDATE/DELETE
> RETURNING syntax in 8.2

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