IS NOT DISTINCT FROM evaluates whether two values are equivalent or whether each one is equal to null.

Structure

IS NOT DISTINCT FROM

Example

Modifying our example from last week: Suppose we want to return records from a table where the upload date of a file is the same as the update date. Here is how we go about it:

SELECT filename, upload_date, update_date WHERE upload_date IS NOT DISTINCT FROM update_date;