Re: PL/Perl: spi_prepare() and RETURNING

"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> On 8/24/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> This reminds me of a consideration I had been intending to bring up on
>> the mailing lists: what exactly do we want to do with the SPI API for
>> RETURNING queries?

> I like adding RETURNING-specific return codes.

>> Another issue I noted in that same area is that spi.c does not set
>> SPI_processed for a utility statement, even if the utility statement
>> returns tuples.  Is this a bug, or should we leave it alone?

> I think it's a bug.

I've applied a patch along these lines.  David's plperl example now does
what (I think) he expected.  Does anyone want to extend the plperl,
pltcl, plpython regression tests to check behavior with INSERT RETURNING
etc?
        regards, tom lane