IS NOT DISTINCT FROM
operator is a counterpart to IS DISTINCT FROM
.
It compares two values, treating them as equal even when they are both NULL
. This operator returns TRUE
if the two values are the same, including the case where both values are NULL
and FALSE
if they are different.
value1
is the first value for comparison.value2
is the second value for comparison.customer_contacts table
where the email and phone are NULL. We can conclude that the customer with customer_id 104
has no phone number or email address.