select count(1) from snapshotlist where id not in (select id from q);
count
-------
0
(1 row)
Doesn't this usually happen if q.id contains NULL. That is as per ANSI standard.
- Select .... where id not in (....) returns 0 incorrectly J. Roeleveld
- Re: Select .... where id not in (....) returns 0 inco... Ravi Krishna
- Re: Select .... where id not in (....) returns 0 ... Jeremy Smith
- Re: Select .... where id not in (....) return... J. Roeleveld
- Re: Select .... where id not in (....) re... David Rowley
- Re: Select .... where id not in (...... J. Roeleveld
- Re: Select .... where id not in (....) re... Mladen Gogala
- Re: Select .... where id not in (...... Peter J. Holzer
