WHERE NOT IN and NULL in Postgresql

NULL values trip up the WHERE NOT IN condition in Postgres. To fix this behavior, use a conditional (not null) in the subquery.

source: http://www.depesz.com/index.php/2008/08/13/nulls-vs-not-in/