Re: Re : BUG #2251: NOT IN clause is not working correctly - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: Re : BUG #2251: NOT IN clause is not working correctly
Date
Msg-id 20060226160713.GB85643@winnie.fuhr.org
Whole thread Raw
In response to Re : BUG #2251: NOT IN clause is not working correctly  (Dhanaraj <Dhanaraj.M@Sun.COM>)
List pgsql-bugs
On Sun, Feb 26, 2006 at 07:38:32PM +0530, Dhanaraj wrote:
> 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..

Sorry, I overlooked that this message was a reply because the
original wasn't quoted.  The behavior is data-dependent -- if you
add some NULLs as in the example I just sent then you should be
able to reproduce it on any platform in any version of PostgreSQL
(at least any modern version).  According to past discussion it's
per the spec.

--
Michael Fuhr

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Re : BUG #2251: NOT IN clause is not working correctly
Next
From: "Kevin Marshall"
Date:
Subject: BUG #2282: Warning: pg_cmdtuples(): Not supported under this build