MAN page from OpenSuSE 13.X dba-postgres-xl-920-9.2-4.1.i586.rpm
SPI_SCROLL_CURSOR_FETCH
Section: Postgres-XL 9.2 Documentation (3)
Updated: 2014-04-30
Index NAME
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_fetchfetches some rows from a cursor. This is equivalent to the SQL commandFETCH.
ARGUMENTS
Portal portal
- portal containing the cursor
FetchDirection direction
- one ofFETCH_FORWARD,FETCH_BACKWARD,FETCH_ABSOLUTEorFETCH_RELATIVE
long count
- number of rows to fetch forFETCH_FORWARDorFETCH_BACKWARD; absolute row number to fetch forFETCH_ABSOLUTE; or relative row number to fetch forFETCH_RELATIVE
RETURN VALUE
SPI_processedandSPI_tuptableare set as inSPI_executeif successful.
NOTES
See the SQLFETCH(7)command for details of the interpretation of thedirectionandcountparameters.
Direction values other thanFETCH_FORWARDmay fail if the cursor's plan was not created with theCURSOR_OPT_SCROLLoption.
Index
- NAME
- SYNOPSIS
- DESCRIPTION
- ARGUMENTS
- RETURN VALUE
- NOTES
This document was created byman2html,using the manual pages.
