Performs comparisons on the individual elements of an ARRAY value, whether referred to in its entirety or over a scope reference.
Syntax
System Function
{ ARRAY_GT | ARRAY_GE | ARRAY_LT | ARRAY_LE | ARRAY_EQ | ARRAY_NE } ( expr1, expr2 [, scope_reference ] )
Method-Style
expr1.{ ARRAY_GT | ARRAY_GE | ARRAY_LT | ARRAY_LE | ARRAY_EQ | ARRAY_NE } ( expr2 [, scope_reference ] )
- expr1
- An ARRAY expression, which is one of the following:
- A reference to an ARRAY column
- An ARRAY constructor expression
- A UDF expression
- A UDM expression
- scope_reference
- An ARRAY scope reference.