Re: Using results from DELETE ... RETURNING - Mailing list pgsql-general

From Tom Lane
Subject Re: Using results from DELETE ... RETURNING
Date
Msg-id 14259.1244243623@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using results from DELETE ... RETURNING  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Using results from DELETE ... RETURNING
List pgsql-general
Merlin Moncure <mmoncure@gmail.com> writes:
> On Fri, Jun 5, 2009 at 6:51 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
>> I think you can loop over the results in plpgsql, for instance

> also sql functions can direct 'returning' results directly to the
> return of the function (at least in 8.4).

That bit is new in 8.4, which is why I didn't mention it.  But I think
the plpgsql loop way works further back.

            regards, tom lane

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Using results from DELETE ... RETURNING
Next
From: "Andi Klapper"
Date:
Subject: PLPython function and multiple line insert