Subject Re: [IB-Architect] Insert Returning
Author Bill Karwin
Jason Wharton wrote:
> Could I please ask for a similar capability to be added to the UPDATE
> statement?
> update <table>
> set <acol> = <aexpr>
> ...
> where <singleton select criteria>
> returning <col list>

It's not clear how to return values in the RETURNING clause if the
operation affects multiple rows. But if one could do it with a cursor
for the INSERT case, it should be possible to do it for the UPDATE case
as well.

Bill Karwin