IS DISTINCT FROM evaluate null as a value that is known instead of evaluating it as an unknown.
IS DISTINCT FROM
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;