tencent cloud

Stream Compute Service

문서Stream Compute ServiceSQL Developer GuideOperators and Built-in FunctionsLogic Functions

Logic Functions

Download
포커스 모드
폰트 크기
마지막 업데이트 시간: 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.

이전 주제: Comparison Functions다음 주제: Arithmetic Functions

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백