SPI_scroll_cursor_fetch — fetch some rows from a cursor
SPI_scroll_cursor_fetch fetches some rows from a cursor. This is equivalent to the SQL command
portal containing the cursor
number of rows to fetch for
FETCH_BACKWARD; absolute row number to fetch for
FETCH_ABSOLUTE; or relative row number to fetch for
SPI_tuptable are set as in
SPI_execute if successful.
See the SQL FETCH command for details of the interpretation of the
Direction values other than
FETCH_FORWARD may fail if the cursor's plan was not created with the
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.