Hi Dmitry! On 27 Sep 05 at 16:16, "Dmitry" (Dmitry Karasik) wrote to "Andrew Dunstan":
Andrew> Meanwhile, I will observe that this very desirable feature needs Andrew> an interface with spi_fetchrow() I re-worked the patch ( http://www.karasik.eu.org/misc/plperl.diff ) and now there's also spi_query_prepared(), that returns a cursor for a previously prepared query that is to be used with subsequent spi_fetchrow() calls. I also modified spi_fetchrow() itself to avoid a couple of memory leaks, and added spi_cursor_close() for cases where not all rows are fetched. -- Sincerely, Dmitry Karasik ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings