Stream Compute Service
- Releases Notes and Announcements
- Getting Started
- Operation Guide
- Managing Jobs
- Developing Jobs
- Monitoring Jobs
- Events and Diagnosis
- Managing Metadata
- Tuning Jobs
- Managing Clusters
- Managing Permissions
- SQL Developer Guide
- DDL Statements
- Connectors
- SET Statement
- Operators and Built-in Functions
- Identifiers and Reserved Words
- ETL Developer Guide
DocumentationStream Compute ServiceSQL Developer GuideOperators and Built-in FunctionsLogic Functions
Logic Functions
Last updated: 2023-11-08 14:20:13
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. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No