BUG #4816: NOT IN clause, doesn't work - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      4816
Logged by:          jose soares
Email address:      jose.saores@sferacarta.com
PostgreSQL version: 8.3.5
Operating system:   x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real
(Debian 4.3.2-1) 4.3.2
Description:        NOT IN clause, doesn't work
Details:

Hello all,

I'm trying a NOT IN clause, but seems it doesn't work. Please take a look:


mydb=# select distinct id from psop where id_ua = 72492;
  id
-------
 56844
 67953
 67955
(3 rows)

mydb=# select distinct id_sop from scad where id_ua = 72492;
----------------
          56844
          67953

(3 rows)

mydb=# select distinct id from psop where id_ua = 72492 and id not in
(select distinct id_sop from scad where id_ua = 72492);
 id
----
(0 rows)

mydb=# select distinct id from psop where id_ua = 72492 and id not in
(56844,67953);
  id
-------
 67955
(1 row)


What's wrong with those selects?

j