omar@tinysofa.org writes:
> Attached is a patch (by Gavin Sherry, fixed up to apply to 8.1 by me) that
> implements INSERT ... RETURNING functionality.
> It does work for the common case of RETURNING the value of a serial/sequence
> column, but gets confused when returning results out-of-order (CREATE TABLE x
> (a int, b int), INSERT ... RETURNING b, a) and doesn't let you specify the same
> column multiple times (INSERT ... RETURNING b, b). These will be addressed
> soon.
This is pretty considerably shy of what I thought had been agreed to
anyway:
- should allow expressions not only column names
- should work for UPDATE and DELETE too
regards, tom lane