=?ISO-8859-1?Q?J=E9r=F4me?= Calais <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
