Postgres Pro
Downloads
Home   >   mailing lists

Re: Select .... where id not in (....) returns 0 incorrectly - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Select .... where id not in (....) returns 0 incorrectly
Date
Msg-id 2ddba2d73d0d54da3396ff2dad9e7d2d@vivaldi.net
Whole thread Raw
In response to Select .... where id not in (....) returns 0 incorrectly  ("J. Roeleveld" <joost@antarean.org>)
Responses Re: Select .... where id not in (....) returns 0 incorrectly  (Jeremy Smith <jeremy@musicsmith.net>)
List pgsql-general
Tree view 
> 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.

pgsql-general by date:

Previous
From: Sebastien Flaesch
Date:
Subject: Re: Transaction and SQL errors
Next
From: Jeremy Smith
Date:
Subject: Re: Select .... where id not in (....) returns 0 incorrectly