1SPI_CURSOR_MOVE(3)       PostgreSQL 14.3 Documentation      SPI_CURSOR_MOVE(3)
2
3
4

NAME

6       SPI_cursor_move - move a cursor
7

SYNOPSIS

9       void SPI_cursor_move(Portal portal, bool forward, long count)
10

DESCRIPTION

12       SPI_cursor_move skips over some number of rows in a cursor. This is
13       equivalent to a subset of the SQL command MOVE (see
14       SPI_scroll_cursor_move for more functionality).
15

ARGUMENTS

17       Portal portal
18           portal containing the cursor
19
20       bool forward
21           true for move forward, false for move backward
22
23       long count
24           maximum number of rows to move
25

NOTES

27       Moving backward may fail if the cursor's plan was not created with the
28       CURSOR_OPT_SCROLL option.
29
30
31
32PostgreSQL 14.3                      2022                   SPI_CURSOR_MOVE(3)
Impressum