Purpose
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
Method-Style
- 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.