Performs a pairwise comparison of the elements of two arrays and returns a value of 1, 0, or NULL to indicate whether or not the two array arguments contain the same element values.
Syntax
System Function
ARRAY_COMPARE ( expr1, expr2 [, scope_reference, nulls_equal_flag ] )
Method-Style
expr1.ARRAY_COMPARE ( expr2 [, scope_reference, nulls_equal_flag ] )
- expr1/expr2
- 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.
- nulls_equal_flag
- A flag that specifies how NULL element values should be compared. Valid values for this parameter are 0 and 1.