Firebird Documentation Index → Firebird 1.5 Language Ref. Update → PSQL statements
Firebird Home Firebird Home Prev: SAVEPOINTFirebird Documentation IndexUp: Firebird 1.5 Language Ref. UpdateNext: BEGIN ... END blocks may be empty

Chapter 8: PSQL statements

Table of Contents

BEGIN ... END blocks may be empty
BREAK
DECLARE [VARIABLE] with initialization
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
Caveats with EXECUTE STATEMENT
EXIT
FOR EXECUTE STATEMENT ... DO
FOR SELECT ... INTO ... DO
AS CURSOR clause
LEAVE
PLAN allowed in trigger code

Tip

Find a more recent version at Firebird 5.0 Language Reference: Procedural SQL (PSQL) Statements

PSQL – Procedural SQL – is the Firebird stored procedure and trigger language.

Prev: SAVEPOINTFirebird Documentation IndexUp: Firebird 1.5 Language Ref. UpdateNext: BEGIN ... END blocks may be empty
Firebird Documentation Index → Firebird 1.5 Language Ref. Update → PSQL statements