SPI_scroll_cursor_move — move a cursor
void SPI_scroll_cursor_move(Portalportal
, FetchDirectiondirection
, longcount
)
SPI_scroll_cursor_move
skips over some number of rows
in a cursor. This is equivalent to the SQL command
MOVE.
Portal portal
portal containing the cursor
FetchDirection direction
one of FETCH_FORWARD, FETCH_BACKWARD, FETCH_ABSOLUTE or FETCH_RELATIVE
long count
number of rows to move for FETCH_FORWARD or FETCH_BACKWARD; absolute row number to move to for FETCH_ABSOLUTE; or relative row number to move to for FETCH_RELATIVE
SPI_processed
is set as in
SPI_execute
if successful.
SPI_tuptable
is set to NULL, since
no rows are returned by this function.
See the SQL FETCH command
for details of the interpretation of the
direction
and
count
parameters.
Direction values other than FETCH_FORWARD may fail if the cursor's plan was not created with the CURSOR_OPT_SCROLL option.