| From: | Alan Nilsson <anilsson(at)apple(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need an explanation |
| Date: | 2013-05-08 02:33:54 |
| Message-ID: | 949A8944-6952-4687-8B21-CCB61A2DED72@apple.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)apple(dot)com> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Uckun | 2013-05-08 02:49:09 | Re: Shortcut evaluation in OR or IN |
| Previous Message | Tom Lane | 2013-05-08 02:30:46 | Re: Need an explanation |