2.8 Row value constructors

Organization of this section
(1) Function
(2) Format
(3) Rules

(1) Function

Specifies either rows or a list of ordered columns.

(2) Format

row-value-constructor::= {row-value-constructor-element
   | (row-value-constructor-element
      [,row-value-constructor-element] ...) | row-subquery}
row-value-constructor-element::= value-expression

(3) Rules

  1. The maximum number of row value constructor elements that can be specified in a row value constructor is 255.
  2. The following data types cannot be specified for columns of the results of a row value constructor:
    • BLOB
    • BINARY with a minimum definition length of 32,001 bytes
    • Abstract data type
    • BOOLEAN
  3. In the specification of two or more row value constructor elements, if a repetition column is specified as a row value constructor element, the subscript ANY cannot be specified.
  4. For details about row subqueries, see 2.4 Subqueries.