The following bug has been logged online: Bug reference: 4816 Logged by: jose soares Email address: jose.sao...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs