Re: unexpected results with NOT IN query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mason Hale" <masonhale(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unexpected results with NOT IN query
Date: 2008-03-20 15:15:49
Message-ID: 10091.1206026149@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mason Hale" <masonhale(at)gmail(dot)com> writes:
> I'm getting some unexpected results with a NOT IN query -- this is on 8.2.5.

If there are any NULLs in subscription.last_feed_download_task_id, that
NOT IN will not behave the way you are expecting. You might want to
filter the nulls out of the subselect result ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2008-03-20 15:17:37 Re: unexpected results with NOT IN query
Previous Message Mason Hale 2008-03-20 14:45:25 unexpected results with NOT IN query