select NOT IN with NULL bug on 7.2b3
От | Giuseppe Tanzilli - CSF |
---|---|
Тема | select NOT IN with NULL bug on 7.2b3 |
Дата | |
Msg-id | 3C066162.9070504@gruppocsf.com обсуждение исходный текст |
Ответы |
Re: select NOT IN with NULL bug on 7.2b3
Re: select NOT IN with NULL bug on 7.2b3 |
Список | pgsql-hackers |
Hi, it is a bug ?? create table test (t1 int4, t2 int4); insert into test values (1,1); insert into test values (2,2); insert into test values (3,1); insert into test values (4,1); insert into test values (4,1); insert into test values (4,null); select * from test where t1 not in (select t2 from test); 0 rows select * from test where t1 not in (select null); 0 rows If I delete the row with null value it works as expected. The IN clause work as expected with or without null row. sorry for my english. bye -- ------------------------------------------------------- Giuseppe Tanzilli g.tanzilli@gruppocsf.com CSF Sistemi srl phone ++39 0775 7771 Via del Ciavattino Anagni FR Italy
В списке pgsql-hackers по дате отправления: