proposed todo: use insert/update returning anywhere a table is allowed

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: proposed todo: use insert/update returning anywhere a table is allowed
Date: 2007-02-06 21:54:20
Message-ID: b42b73150702061354y2db729acu55dc37c8a4e51db6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

It would be great to be able to join to update, returning, etc. It
looks like the code was deliberately tied off as-is and I was
surprised not to see a todo for this.

the basic idea is to be able to do things like:
select * from (update foo set id = 1 returning *) q;

which currently syntax errors out on 'set' which is a bit odd.

here are tom's brief notes on it and also some context on how select
combined with insert/update might influence triggers:

http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php

merlin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-02-06 21:57:47 Re: Status of autovacuum and the sporadic stats failures ?
Previous Message Andrew Dunstan 2007-02-06 21:52:32 Re: Status of autovacuum and the sporadic stats failures ?