SQL & PL/pgSQL Functions
Function declarations in all languages: simple SQL, PL/pgSQL, set-returning, variadic, trigger, and named dollar-quoting.
Functions
SQL and PL/pgSQL functions, function attributes, procedures, and aggregate functions.
| Page | Description |
|---|---|
| SQL & PL/pgSQL | Function declarations in all languages |
| Attributes | VOLATILE, STABLE, IMMUTABLE, STRICT, SECURITY DEFINER, PARALLEL, and more |
| Procedures | PROCEDURE declarations with COMMIT support |
| Aggregates | AGGREGATE with SFUNC, STYPE, FINALFUNC, and ordered-set variants |
Function Attributes
Volatility, strictness, security, parallelism, cost, rows, support, SET, and WINDOW attributes.
Procedures
PROCEDURE declarations; procedures may COMMIT mid-execution.
Aggregates
AGGREGATE declarations with SFUNC, STYPE, INITCOND, FINALFUNC, and ordered-set variants.