IS [ NOT ] DISTINCT FROM
Compares whether two expressions are equal (or not equal) with awareness of nullability, meaning it treats NULLs as known values for comparing equality.
Syntax
<expr1> IS [ NOT ] DISTINCT FROM <expr2>
Compares whether two expressions are equal (or not equal) with awareness of nullability, meaning it treats NULLs as known values for comparing equality.
<expr1> IS [ NOT ] DISTINCT FROM <expr2>