On Mon, Jun 01, 2009 at 04:21:27PM +0100, Shak wrote: > When RETURNING from a DELETE statement (or similar), how do you access the > results being returned? > > Something like: > > SELECT COUNT(*) FROM (DELETE FROM a RETURNING *) ; > > sounds reasonable but results in a syntax error. I am able to return single > results into a variable or record, but not more than one result.
You can't. It's on the TODO list (http://wiki.postgresql.org/wiki/Todo). Look for "Allow INSERT/UPDATE ... RETURNING" and "Allow INSERT ... DELETE ... RETURNING" - Josh / eggyknap
signature.asc
Description: Digital signature
