Weird NOT IN effect with NULL values - Mailing list pgsql-sql

From Frank Joerdens
Subject Weird NOT IN effect with NULL values
Date
Msg-id 20010301191654.A12406@rakete.joerdens.de
Whole thread Raw
Responses Re: Weird NOT IN effect with NULL values  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Weird NOT IN effect with NULL values  (Peter Eisentraut <peter_e@gmx.net>)
Re: Weird NOT IN effect with NULL values  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Weird NOT IN effect with NULL values  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
When doing a subselect with NOT IN, as in

SELECT name
FROM customer
WHERE customer_id NOT IN (
SELECT customer_id
FROM salesorder
);

(from Bruce Momjian's book)

I get no rows if the result column returned by the subselect
contains NULL values. It works as expected if I remove the NULL values
from the result set. Is this behaviour correct and if so, why?

I am using 7.1 beta 4.

Regards, Frank


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: BufTableDelete: BufferLookup table corrupted
Next
From: Josh Berkus
Date:
Subject: Re: Weird NOT IN effect with NULL values