Skip to main content
Version: 24.3.x

Categories: Boolean, Datatype

IS [NOT] TRUE

Tests whether the input expression is either true or not true. If true in either case, returns a value of true. Alias for the function ISTRUE/ISNOTTRUE.

Syntax

IS [NOT] TRUE(expression int64) → boolean

  • expression: Input expression.

Examples

ISTRUE example
SELECT ISTRUE(1)
-- True

IS [NOT] TRUE(expression boolean) → boolean

  • expression: Input expression.

Examples

ISTRUE example
SELECT ISTRUE(FALSE)
-- False

IS [NOT] TRUE(expression int32) → boolean

  • expression: Input expression.

Examples

ISTRUE example
SELECT ISTRUE(0)
-- False

IS [NOT] TRUE(expression int64) → boolean

  • expression: Input expression.

Examples

ISNOTTRUE example
SELECT ISNOTTRUE(1)
-- False

IS [NOT] TRUE(expression boolean) → boolean

  • expression: Input expression.

Examples

ISNOTTRUE example
SELECT ISNOTTRUE(FALSE)
-- True

IS [NOT] TRUE(expression int32) → boolean

  • expression: Input expression.

Examples

ISNOTTRUE example
SELECT ISNOTTRUE(0)
-- True