Joshua Tolley <eggyk...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
