Supported ARRAY Comparison Functions | Data Types & Literals | Teradata Vantage - 17.10 - Supported ARRAY Comparison Functions - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

The following table provides a description of the supported ARRAY comparison functions.

Relational Function Description
ARRAY_GT Greater than function. Compares two expressions and determines whether expr1 is greater than expr2. If it is, the function returns a non-zero value in the corresponding result ARRAY element. If expr1 is less than or equal to expr2, the function returns zero in the corresponding result ARRAY element.
ARRAY_GE Equal or greater than function. Compares two expressions and determines whether expr1 is greater than or equal to expr2. If it is, the function returns a non-zero value in the corresponding result ARRAY element. If expr1 is less than expr2, the function returns zero in the corresponding result ARRAY element.
ARRAY_LT Less than function. Compares two expressions and determines whether expr1 is less than expr2. If it is, the function returns a non-zero value in the corresponding result ARRAY element. If expr1 is greater than or equal to expr2, the function returns zero in the corresponding result ARRAY element.
ARRAY_LE Equal or less than function. Compares two expressions and determines whether expr1 is less than or equal to expr2. If it is, the function returns a non-zero value in the corresponding result ARRAY element. If expr1 is greater than expr2, the function returns zero in the corresponding result ARRAY element.
ARRAY_EQ Equality function. Compares two expressions and determines whether expr1 is equal to expr2. If it is, the function returns a non-zero value in the corresponding result ARRAY element. If expr1 is not equal to expr2, the function returns zero in the corresponding result ARRAY element.
ARRAY_NE Non-equality function. Compares two expressions and determines if expr1 is not equal to expr2. If the two expressions are not equal, the function returns a non-zero value in the corresponding result ARRAY element. If expr1 is equal to expr2, the function returns zero in the corresponding result ARRAY element.