Re: NOT IN issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc SCHAEFER <schaefer(at)alphanet(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: NOT IN issue
Date: 2001-07-04 17:00:46
Message-ID: 27962.994266046@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Perhaps there are some NULLs in the sub-SELECT's result? See the archives
concerning the not-very-intuitive behavior of NOT IN with NULL.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chuck Shunk 2001-07-04 17:05:05 Remote queries
Previous Message Scott Holmes 2001-07-04 16:38:04 Re: Re: lo wrappers - still working on it