Joshua Tolley <eggyknap@xxxxxxxxx> writes: > On Mon, Jun 01, 2009 at 04:21:27PM +0100, Shak wrote: >> 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). I think you can loop over the results in plpgsql, for instance for rec in DELETE FROM a RETURNING * loop ... do something with rec ... end loop; regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
