Re: creating WITH HOLD cursors using SPI - Mailing list pgsql-hackers

From Tom Lane
Subject Re: creating WITH HOLD cursors using SPI
Date
Msg-id 23880.1118588881@sss.pgh.pa.us
Whole thread Raw
In response to creating WITH HOLD cursors using SPI  (Abhijit Menon-Sen <ams@oryx.com>)
Responses Re: creating WITH HOLD cursors using SPI
List pgsql-hackers
Abhijit Menon-Sen <ams@oryx.com> writes:
> I've been working on making it possible for PL/Perl users to fetch large
> result sets one row at a time (the current spi_exec_query interface just
> returns a big hash).

> The idea is to have spi_query call SPI_prepare/SPI_open_cursor, and have
> an spi_fetchrow that calls SPI_cursor_fetch.

This seems awfully limiting; isn't return_next a better API?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Michael Glaesemann
Date:
Subject: interval->day first cut
Next
From: "Andrew Dunstan"
Date:
Subject: Re: creating WITH HOLD cursors using SPI