ARRAY_COMPARE - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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.