On Fri, Jun 5, 2009 at 6:51 PM, Tom Lane<t...@sss.pgh.pa.us> wrote: > 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
also sql functions can direct 'returning' results directly to the return of the function (at least in 8.4). merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general