Description

frees the resources associated with an open cursor. After the cursor is closed, no subsequent operations are allowed on it. A cursor should be closed when it is no longer needed.

Every non-holdable open cursor is implicitly closed when a transaction is terminated by COMMIT or ROLLBACK. A holdable cursor is implicitly closed if the transaction that created it is prematurely ended via . If the creating transaction successfully commits, the holdable cursor remains open until an explicit CLOSE is run, or the client disconnects.

cursor_name

Notes

Greenplum Database does not have an explicit OPEN cursor statement. A cursor is considered open when it is declared. Use the statement to declare (and open) a cursor.

You can see all available cursors by querying the pg_cursors system view.

If a cursor is closed after a savepoint which is later rolled back, the CLOSE is not rolled back; that is the cursor remains closed.

Compatibility

CLOSE is fully conforming with the SQL standard.

DECLARE, , MOVE,

Parent topic: SQL Commands