Re: [HACKERS] SPI cursor functions

2008-10-27 Thread Tim Keitt
On Fri, Oct 24, 2008 at 7:57 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Tim Keitt" <[EMAIL PROTECTED]> 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

Re: [HACKERS] SPI cursor functions

2008-10-24 Thread Tom Lane
"Tim Keitt" <[EMAIL PROTECTED]> 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

[HACKERS] SPI cursor functions

2008-10-24 Thread Tim Keitt
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? Also, I noticed that SPI_scroll_cursor_move(someportal, FETCH_BACKWARD, 1); sets S