Cloud

Boolean Functions

  • if

    The `if()` function returns one value if the condition is TRUE and another value if the condition is FALSE.

  • IS DISTINCT FROM

    The IS DISTINCT FROM operator compares two values and returns TRUE if they are different. NULLs are treated as comparable, so two NULLs are not distinct (returns FALSE).

  • IS NOT DISTINCT FROM

    The IS NOT DISTINCT FROM operator is a counterpart to IS DISTINCT FROM.