FETCH cursor

Available in: PSQL

Added in: 2.0

Description: Fetches the next data row from a cursor's result set and stores the column values in PSQL variables.

Syntax:

FETCH cursorname INTO [:]varname [, [:]varname ...];

Notes:

The ROW_COUNT context variable will be 1 if the fetch returned a data row and 0 if the end of the set has been reached.
You can do a positioned UPDATE or DELETE on the fetched row with the WHERE CURRENT OF clause.