Firebird Documentation IndexFirebird 2.5 Language Ref. Update → PSQL statements
Firebird Home Firebird Home Prev: SET TRANSACTIONFirebird Documentation IndexUp: Firebird 2.5 Language Ref. UpdateNext: BEGIN ... END blocks may be empty

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

PSQL – Procedural SQL – is the Firebird programming language used in stored procedures, triggers and executable blocks.

Prev: SET TRANSACTIONFirebird Documentation IndexUp: Firebird 2.5 Language Ref. UpdateNext: BEGIN ... END blocks may be empty
Firebird Documentation IndexFirebird 2.5 Language Ref. Update → PSQL statements