本文介绍了PolarDB-X 1.0支持的比较函数。
PolarDB-X 1.0支持如下比较函数:
函数名 | 描述 |
---|---|
COALESCE() | Return the first non-NULL argument |
GREATEST() | Return the largest argument |
IN() | Check whether a value is within a set of values |
INTERVAL() | Return the index of the argument that is less than the first argument |
ISNULL() | Test whether the argument is NULL |
LEAST() | Return the smallest argument |
NOT IN() | Check whether a value is not within a set of values |
STRCMP() | Compare two strings |