Supported ARRAY Comparison Functions

Teradata Vantageā„¢ Data Types and Literals

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

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.