PostgreSQL
Description
SPI_scroll_cursor_move
skips over some number of rows in a cursor. This is equivalent to the SQL command MOVE
.
Arguments
- `Portal +`_`+portal`_
-
portal containing the cursor
- `FetchDirection +`_`+direction`_
-
one of
FETCH_FORWARD
,FETCH_BACKWARD
,FETCH_ABSOLUTE
orFETCH_RELATIVE
- `long +`_`+count`_
-
number of rows to move for
FETCH_FORWARD
orFETCH_BACKWARD
; absolute row number to move to forFETCH_ABSOLUTE
; or relative row number to move to forFETCH_RELATIVE
Return Value
SPI_processed
is set as in SPI_execute
if successful. SPI_tuptable
is set to NULL
, since no rows are returned by this function.
Submit correction
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.
Copyright © 1996-2023 The PostgreSQL Global Development Group