IN selection issues

Jï¿œrï¿œme Calais writes:

delete from status where status_id not in (select distinct status_id
from company);

"status_id" is a foreign key in "company".

It does not delete any records from status table whereas it should
because the sub query returns some records.

There are probably null values in the result set of the subselect.

--
Peter Eisentraut peter_e@gmx.net

=?ISO-8859-1?Q?J=E9r=F4me?= Calais <jerome.calais@arunix.fr> writes:

I am encountering problems with IN selections.
I am trying this query :
delete from status where status_id not in (select distinct status_id
from company);

I'll bet the sub-select yields some NULL rows? If so, this is not a
bug. NOT IN is not very intuitive about handling of NULLs. I suggest
you consult a SQL textbook ...

regards, tom lane