IS [NOT] DISTINCT FROM
Compares two expressions to determine whether they have the same or different values. NULLs are considered as comparable values.
Syntax
IS [NOT] DISTINCT FROM(expression any) → boolean
expression: Can be a general expression of any Spice-supported data type.
Examples
SELECT NULL IS DISTINCT
FROM NULL
-- False
SELECT NULL IS NOT DISTINCT
FROM NULL
-- True
Last updated
Was this helpful?