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 SPI_processed to 0, not 1. Is that the intended behavior? How
does one check for a failed backwards move?

Thanks.

THK

-- 
Timothy H. Keitt
University of Texas at Austin http://www.keittlab.org/
Contact info and schedule at http://www.keittlab.org/~tkeitt/
Publications http://www.keittlab.org/biblio

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to