Ann W. Harrison wrote:

>
> INSERT INTO <whatever> SELECT <list> FROM <data source> YIELDING
> ...
>
> A question is whether the ability to return a transient data set from
> an update or delete has value, since those operations are not based
> on a full query expression.

I think the important need is for INSERT, not for deletions and updates,
unless somebody shows a compelling case.

When RETURNING or YIELDING produce rows, are those rows the ones that are
stored in the engine? I ask to be sure, since I may want to insert (a,b,c)
in a row, but pre modify triggers change those values before being stored.

C.