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