Re: creating WITH HOLD cursors using SPI

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Abhijit Menon-Sen <ams(at)oryx(dot)com>
Cc: plperlng-devel(at)pgfoundry(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: creating WITH HOLD cursors using SPI
Date: 2005-06-12 15:08:01
Message-ID: 23880.1118588881@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Abhijit Menon-Sen <ams(at)oryx(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-06-12 16:25:36 Re: creating WITH HOLD cursors using SPI
Previous Message Michael Glaesemann 2005-06-12 14:26:53 interval->day first cut