Skip to main content

Module validation

Module validation 

Source
Expand description

Set-returning expression detection and SQL context validation.

Functions§

builtin_returns_set
expression_may_return_set
function_may_return_set
projections_may_return_set
resolve_set_function_binding
validate_projection_set_contexts
validate_query_set_contexts
Check a query block’s clauses in PostgreSQL’s transformation order: the target list, WHERE, HAVING, ORDER BY, GROUP BY, DISTINCT ON, OFFSET, LIMIT and FROM, then the row-locking clause. A block of a stored definition is not checked again.
validate_source_set_contexts_before_build
validate_values_set_contexts