Search Postgresql Archives

Re: Select .... where id not in (....) returns 0 incorrectly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Select .... where id not in (....) returns 0 incorrectly
From: Ravi Krishna <srkrishna@xxxxxxxxxxx>
Date: Mon, 04 Apr 2022 08:44:15 -0400
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <5820573.lOV4Wx5bFT@iris>
References: <5820573.lOV4Wx5bFT@iris>

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 ANSIstandard.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Select .... where id not in (....) returns 0 incorrectly
  - From: Jeremy Smith

References:
- Select .... where id not in (....) returns 0 incorrectly
  - From: J. Roeleveld

Prev by Date: Re: Transaction and SQL errors
Next by Date: Re: Select .... where id not in (....) returns 0 incorrectly
Previous by thread: Select .... where id not in (....) returns 0 incorrectly
Next by thread: Re: Select .... where id not in (....) returns 0 incorrectly
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux