IS DISTINCT FROM evaluate null as a value that is known instead of evaluating it as an unknown.

Structure

IS DISTINCT FROM

Example

Suppose we want to return records from a table where the upload date of a file is different from the update date. Here is how we go about it:

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