On Sun, Jun 7, 2009 at 12:29 AM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> David Fetter <david@fetter.org> writes:
>> Would it be super-complicated to do this with CTEs for 8.5? They seem to
>> have sane properties like getting executed exactly once.
>
> Hmm, interesting thought. The knock against doing RETURNING as an
> ordinary subquery is exactly that you can't disentangle it very well
> from the upper query (and thus, it's hard to figure out when to fire
> triggers, to take just one problem). But we've defined CTEs much more
> restrictively, so maybe the problems can be solved in that context.
>
being able to do this would probably give 'best of class' approach to
dealing with update/insert rules to views that want to work
w/returning clause (although, still a complete mess), plus numerous
other useful things.
merlin