Expand description
Where a set-returning call may appear, and the diagnostics PostgreSQL reports for one that may not.
Enums§
- SetPlacement
- The kind of expression under analysis, as
PostgreSQL’scheck_srf_call_placementdistinguishes them byParseExprKind.
Functions§
- conditional_
set_ error - A construct that evaluates its inputs conditionally or once per group or window, and so cannot contain a set-returning call:
CASEandCOALESCE, and the arguments of an aggregate or window function call. - row_
comparison_ set_ error - A row comparison, or the comparison of a subquery test expression, whose operator returns a set.
- set_
argument_ error - A set-valued operand of a construct that requires a single value, as
coerce_to_booleanreports it. - set_
valued_ call_ error - A set-returning call reached an expression evaluated for one value, as
PostgreSQL’s executor reports it when it initializes such an expression. - top_
level_ from - A set-returning call nested in a function in FROM.