DESCRIPTION

PARAMETERS

name
FETCH
BINARYINSENSITIVE
PostgreSQL SQL
SCROLLNOSCROLL
SCROLL SCROLL NO SCROLL
WITHHOLDWITHOUTHOLD
WITH HOLD WITHOUT HOLD WITHOUT HOLD WITH HOLD WITH HOLD
query
SELECT SELECT
FORREADONLYFORUPDATE
FOR READ ONLY FOR UPDATE PostgreSQL FOR UPDATE FOR READ
ONLY
column
PostgreSQL FOR UPDATE
BINARYINSENSITIVESCROLL

NOTES

WITH HOLD Thus, DECLARE without WITH HOLD is useless outside a
transaction block: the cursor would survive only to the completion of
the statement. Therefore PostgreSQL reports an error if this command is
used outside a transaction block. BEGIN [begin(7)], COMMIT [commit(7)]
ROLLBACK [rollback(7)]
WITH HOLD WITH HOLD CLOSE
SCROLL SQL PostgreSQL SCROLL SCROLL NO SCROLL
SQL SQL ESQL PostgreSQL OPEN PostgreSQL SQL ecpg SQL92
DECLAREOPEN