is-not-distinct-from.md

description
Compares two expressions to determine whether they have the same or different values. NULLs are considered as comparable values.

IS [NOT] DISTINCT FROM

Syntax

IS [NOT] DISTINCT FROM(expression any) → boolean

• expression: Can be a general expression of any Spice-supported data type.

Examples

{% code title="IS [NOT] DISTINCT FROM example" %}

SELECT NULL IS DISTINCT
FROM NULL

-- False

{% endcode %}

{% code title="IS [NOT] DISTINCT FROM example" %}

SELECT NULL IS NOT DISTINCT
FROM NULL

-- True

{% endcode %}