PSQL statements

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

---

• BEGIN ... BLOCKS may be empty
• BREAK
• CLOSE cursor
• DECLARE
• EXCEPTION
• EXECUTE PROCEDURE
• EXECUTE STATEMENT
• EXIT
• FETCH cursor
• FOR EXECUTE STATEMENT ... DO
• FOR SELECT INTO ... DO
• LEAVE
• OPEN cursor
• PLAN allowed in trigger code
• UDFs callable as void functions
• WHERE CURRENT OF valid again for view cursors