本文介绍了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 |