select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.3 / 7.2
Historical version. PostgreSQL 7.3 reached end of support in November 2007. See the current manual for supported releases.

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.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.