Comment

Comment by wefarrell

Null values and inequality are extremely counterintuitive (in postgres at least). If you run the query:

  SELECT * FROM my_table WHERE my_column != 5

You would expect it to return rows that have a null value for my_column, since null is not 5. However that is not the case.

Discussion