On Sun, Jun 7, 2009 at 12:29 AM, Tom Lane<tgl@xxxxxxxxxxxxx> wrote: > David Fetter <david@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
