Chapter 9: PSQL statements

Table of Contents

BEGIN ... END blocks may be empty

BREAK

CLOSE cursor

DECLARE

DECLARE ... CURSOR

DECLARE [VARIABLE] with initialization

DECLARE with DOMAIN instead of datatype

TYPE OF COLUMN in variable declaration

COLLATE in variable declaration

NOT NULL in variable declaration

EXCEPTION

Rethrowing a caught exception

Providing a custom error message

EXECUTE PROCEDURE

EXECUTE STATEMENT

No data returned

One row of data returned

Any number of data rows returned

Improved performance

WITH {AUTONOMOUS|COMMON} TRANSACTION

WITH CALLER PRIVILEGES

ON EXTERNAL [DATA SOURCE]

AS USER, PASSWORD and ROLE

Parameterized statements

Caveats with EXECUTE STATEMENT

EXIT

FETCH cursor

FOR EXECUTE STATEMENT ... DO

FOR SELECT ... INTO ... DO

AS CURSOR clause

IN AUTONOMOUS TRANSACTION

LEAVE

OPEN cursor

PLAN allowed in trigger code

Subqueries as PSQL expressions

UDFs callable as void functions

WHERE CURRENT OF valid again for view cursors