The following bug has been logged online:
Bug reference: 3937
Logged by: Jan Mate
Email address: mate(at)yeea(dot)eu
PostgreSQL version: 8.2.6
Operating system: Linux & Mac OS X
Description: timestamp null value comparison in subquery using IN/NOT
IN
Details:
Comparison between null and timestamp null value is not correct.
Try this example:
CREATE TABLE _test ("timestamp" timestamp);
INSERT INTO _test (timestamp) VALUES (null);
SELECT 1 WHERE (null) NOT IN (SELECT * FROM _test);
?column?
----------
(0 rows)
SELECT 1 WHERE (null) IN (SELECT * FROM _test);
?column?
----------
(0 rows)
Is there any other way to compare the subquery result (using IN or NOT IN)
with null value?