PostgreSQL
Description
SPI_scroll_cursor_fetch
fetches some rows from a cursor. This is equivalent to the SQL command FETCH
.
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 fetch for
FETCH_FORWARD
orFETCH_BACKWARD
; absolute row number to fetch forFETCH_ABSOLUTE
; or relative row number to fetch forFETCH_RELATIVE
Notes
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.
Prev | Up | Next |
---|---|---|
SPI_cursor_move |
SPI_scroll_cursor_move |
Copyright © 1996-2023 The PostgreSQL Global Development Group