Skip site navigation (1) Skip section navigation (2)

Re : BUG #2251: NOT IN clause is not working correctly

From: Dhanaraj <Dhanaraj(dot)M(at)Sun(dot)COM>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re : BUG #2251: NOT IN clause is not working correctly
Date: 2006-02-26 14:08:32
Message-ID: 4401B660.9080801@sun.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2251
Logged by:          Sergei Dubov
Email address:      sdubov ( at ) gmail ( dot ) com
PostgreSQL version: 8.1.2
Operating system:   Windows XP
Description:        NOT IN clause is not working correctly
Details:

I have two tables, let's say A and B.

B is a child of a in one to many relationship. A contains records that are
not referenced by B.

I am running a query:

select * from A t1 where t1.id not in (select t2.A_id from B t2);

It returns 0 rows.

Now I run
(select t1.id from A t1) except (select t2.A_id from B t2);

And now Postgres correctly returns records from A that are not referenced by
B.

Thanks a lot for your consideration of this bug.

Serge.

Hi

I tested this exampe. It works fine in Solaris platform (postgres 8.1.2 
released recently by sun)
Try the same example in some other version. If this is true, the changes 
need to be done for a particular version of postgres..

Have a nice time
Dhanaraj




Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2006-02-26 15:45:22
Subject: Re: Re : BUG #2251: NOT IN clause is not working correctly
Previous:From: Kevin MarshallDate: 2006-02-26 11:11:50
Subject: BUG #2282: Warning: pg_cmdtuples(): Not supported under this build

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group