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

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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Dhanaraj <Dhanaraj(dot)M(at)Sun(dot)COM>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Re : BUG #2251: NOT IN clause is not working correctly
Date: 2006-02-26 16:07:13
Message-ID: 20060226160713.GB85643@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-02-26 16:59:29
Subject: Re: BUG #2282: Warning: pg_cmdtuples(): Not supported under this build
Previous:From: Michael FuhrDate: 2006-02-26 15:58:36
Subject: Re: Re : BUG #2251: NOT IN clause is not working correctly

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