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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend