2.1.2.140 S094, Arrays of reference types 2.1.2.141 S095, Array constructors by query 2.1.2.142 S096, Optional array bounds 2.1.2.143 S097, Array element assignment 2.1.2.144 S098, ARRAY_AGG 2.1.2.145 S111, ONLY in query expressions 2.1.2.146 S151, Type predicate 2.1.2.147 S161...
"If array has size zero, or every element of mask has the value .FALSE., the value of the result is controlled by compiler option assume [no]old_maxminloc, which can set the result to either 1 or 0." In this case, it is unclear to me when to expect a value of 1 or 0, and...
element in the predicate vector contains a non-zero value, otherwise, for each element in the result vector to the right of the key element position, setting the element in the result vector equal to a result of a multi-way comparison operation for which the inputs are the base value and...
2.1.2.140 S094, Arrays of reference types 2.1.2.141 S095, Array constructors by query 2.1.2.142 S096, Optional array bounds 2.1.2.143 S097, Array element assignment 2.1.2.144 S098, ARRAY_AGG 2.1.2.145 S111, ONLY in query expressions 2.1.2.146 S151, Type predicate 2.1.2.147 S161,...
"If array has size zero, or every element of mask has the value .FALSE., the value of the result is controlled by compiler option assume [no]old_maxminloc, which can set the result to either 1 or 0." In this case, it is unclear to me when to expect a value of 1 or 0, and...
Subclause 6.28, "<numeric value function>": <max cardinality expression> ::= ARRAY_MAX_CARDINALITY <left paren> <array value expression> <right paren> ... Conformance Rules: Without Feature S403, "ARRAY_MAX_CARDINALITY", conforming SQL language shall not contain <max cardinality exp...
2.1.2.140 S094, Arrays of reference types 2.1.2.141 S095, Array constructors by query 2.1.2.142 S096, Optional array bounds 2.1.2.143 S097, Array element assignment 2.1.2.144 S098, ARRAY_AGG 2.1.2.145 S111, ONLY in query expressions 2.1.2.146 S151, Type predicate 2.1.2.147 S1...
of elements; capturing a base value contained in an element of the first input vector at a key element position; and generating the result vector, wherein generating the result vector involves, if the predicate vector is received, for each element in the result vector to the right of the ...