that was indeed the case. Did not think to look at that, thanks much for the kick :) alan On May 7, 2013, at 7:30 PM, Tom Lane wrote: > Alan Nilsson <anilsson@xxxxxxxxx> writes: >> Could someone explain to me what I'm missing here. > > Probably there are some NULLs in dasp.asp_id. NOT IN cannot succeed > when there are any nulls in the sub-select result: per SQL spec, the > outcome of such a test can only be FALSE or NULL. If that isn't the > behavior you want, try recasting the query to use NOT EXISTS. > > regards, tom lane > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
