September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 7.3 / 7.2
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

SPI_cursor_fetch

Name

SPI_cursor_fetch -- Fetches some rows from a cursor

Synopsis

SPI_cursor_fetch(portal,
forward,
count)

Inputs

Portal portal

Portal containing cursor

bool forward

True for fetch forward, false for fetch backward

int count

Maximum number of rows to fetch

Outputs

SPI_tuptable

initialized as in SPI_exec if successful

SPI_processed

initialized as in SPI_exec if successful

Description

SPI_cursor_fetch fetches some (more) rows from a cursor. This is equivalent to the SQL command FETCH.