Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15604: NOT IN condition incorrectly returns False - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #15604: NOT IN condition incorrectly returns False
Date
Msg-id 87bm473ln6.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #15604: NOT IN condition incorrectly returns False  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
Tree view 
>>>>> "Andrew" == Andrew Gierth <andrew@tao11.riddles.org.uk> writes:

 Andrew> The condition  1 NOT IN (2,NULL)  is equivalent to (1=2) OR
 Andrew> (1=NULL),

I mean NOT ((1=2) OR (1=NULL)) of course, but NOT (NULL) is still NULL.

-- 
Andrew (irc:RhodiumToad)

pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #15604: NOT IN condition incorrectly returns False
Next
From: PG Bug reporting form
Date:
Subject: BUG #15605: Unstable regression test "tablespace"