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. |