- Releases Notes and Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- SQL Developer Guide
- Python Developer Guide
- ETL Developer Guide
- FAQ
- Contact Us
- Releases Notes and Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- SQL Developer Guide
- Python Developer Guide
- ETL Developer Guide
- FAQ
- Contact Us
Logical functions are used to perform logical operations, and the result is a Boolean value.
Three logical statuses are available: TRUE, FALSE, and UNKNOWN (represented by NULL). Therefore, NOT TRUE is not necessarily FALSE; it can also be UNKNOWN.
Function | Description |
boolean1 OR boolean2 | Returns TRUE if boolean1 or boolean2 is TRUE. |
boolean1 AND boolean2 | Returns TRUE if boolean1 and boolean2 are both TRUE. |
NOT boolean | Returns TRUE if boolean is FALSE; returns FALSE if boolean is TRUE; returns UNKNOWN if boolean is UNKNOWN. |
boolean IS FALSE | Returns TRUE if boolean is FALSE; returns FALSE if boolean is UNKNOWN. |
boolean IS NOT FALSE | Returns TRUE if boolean is not FALSE; returns TRUE if boolean is UNKNOWN. |
boolean IS UNKNOWN | Returns TRUE if boolean is UNKNOWN; otherwise FALSE. |
boolean IS NOT UNKNOWN | Returns TRUE if boolean is not UNKNOWN; otherwise FALSE. |
是
否
本页内容是否解决了您的问题？