Row expression

A row expression specifies a row of data that could have a specific user-defined row type or the built-in data type ROW.

Authorization

The use of some of the row expressions may require having the appropriate authorization. For these row expressions, the privileges held by the authorization ID of the statement must include the following authorization:
  • row-variable. For information about authorization considerations when row-variable is a global variable, see Global variables.
  • row-function-invocation. The authorization to execute the function. For information about authorization considerations, see Function invocation in the Functions topic
  • expression. Authorizations might be required for the use of certain expressions referenced in a row-expression. For information about authorization considerations, see Expressions.

Syntax

row-expression
Read syntax diagramSkip visual syntax diagram row-variablerow-case-expressionrow-cast-specificationrow-array-element-specificationrow-field-referencerow-function-invocation

Description

row-variable
A variable that is defined with row type.
row-case-expression
A case-expression that returns a row type.
row-cast-specification
A CAST that returns a row type.
row-array-element-specification
An array-element-specification of an array with row type elements.
row-field-reference
A field-reference of a row where the field is also a row type
row-function-invocation
A function-invocation of a user-defined function that has a return type that is a row type. The function could return a user-defined row type or the data type ROW with defined field names and field types.

Notes

  • Row expressions can be used to generate a row within SQL PL contexts.