Re: SPI cursor functions

"Tim Keitt" <tkeitt(at)keittlab(dot)org> writes:
> The docs for FETCH indicate you can fetch from the current row using
> FORWARD 0, but

> SPI_scroll_cursor_fetch(someportal, FETCH_FORWARD, 0);

> fails for me. Is there a way to emulate FETCH FORWARD 0 with SPI?

Fails how? AFAICS that calls the same code that the SQL-level
FETCH command would.

You do realize that "FORWARD 0" means to re-fetch the current row,
ie the most recently fetched row? There isn't any current row in
the initial state of a cursor.

> Also, I noticed that
> SPI_scroll_cursor_move(someportal, FETCH_BACKWARD, 1);
> sets SPI_processed to 0, not 1. Is that the intended behavior?

Well, it is if you don't have any row to move backward to ...

regards, tom lane