Comparison functions
PolarDB-X supports the following comparison functions.
| Function | Description |
|---|---|
| COALESCE() | Returns the first non-NULL expression in the argument list. |
| GREATEST() | Returns the largest value from a list of expressions. |
| IN() | Tests whether the specified value or field is included in a list. |
| ISNULL() | Tests whether the expression is NULL. |
| LEAST() | Returns the smallest value from a list of expressions. |
| STRCMP() | Compares two strings by ASCII value. Returns 0 if s1 equals s2, 1 if s1 is greater, and -1 if s1 is less. |