ARRAY_COMPARISON_FUNCTION - 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 comparisons on the individual elements of an ARRAY value, whether referred to in its entirety or over a scope reference.

Syntax

System function syntax:

System Function

Method-Style

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.