On 25th of February, Tom Lane committed patch: Support data-modifying commands (INSERT/UPDATE/DELETE) in WITH. This patch implements data-modifying WITH queries according to the semantics that the updates all ...

November 3rd, 2008 by depesz | Tags: , , , , | Comments Off on Waiting for 8.4 – sql-wrappable RETURNING

In PostgreSQL 8.2, we got "RETURNING" clause in INSERT/UPDATE/DELETE queries. Unfortunately it could not be used as source of rows for anything in sql. insert into table_backup delete from table where ... returning *; Well, it's still not possible, but it is a ...