From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/spi-spi-scroll-cursor-fetch.html | 34 ++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 doc/src/sgml/html/spi-spi-scroll-cursor-fetch.html (limited to 'doc/src/sgml/html/spi-spi-scroll-cursor-fetch.html') diff --git a/doc/src/sgml/html/spi-spi-scroll-cursor-fetch.html b/doc/src/sgml/html/spi-spi-scroll-cursor-fetch.html new file mode 100644 index 0000000..fa435cd --- /dev/null +++ b/doc/src/sgml/html/spi-spi-scroll-cursor-fetch.html @@ -0,0 +1,34 @@ + +SPI_scroll_cursor_fetch
SPI_scroll_cursor_fetch
Prev Up46.1. Interface FunctionsHome Next

SPI_scroll_cursor_fetch

SPI_scroll_cursor_fetch — fetch some rows from a cursor

Synopsis

+void SPI_scroll_cursor_fetch(Portal portal, FetchDirection direction,
+                             long count)
+

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 or + FETCH_RELATIVE +

long count

+ number of rows to fetch for + FETCH_FORWARD or + FETCH_BACKWARD; absolute row number to fetch for + FETCH_ABSOLUTE; or relative row number to fetch for + FETCH_RELATIVE +

Return Value

+ SPI_processed and + SPI_tuptable are set as in + SPI_execute if successful. +

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 Home SPI_scroll_cursor_move
\ No newline at end of file -- cgit v1.2.3