Tom Lane said:
> Abhijit Menon-Sen <[EMAIL PROTECTED]> 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?
>
plperl already does return_next for handing data back to postgres (see
recently applied patch). I don't understand how we can use it when fetching
data from postgres into plperl, which is what Abhijit is working on.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
