Horton

exists <==> not exists ???

Christian Breimann <chr@math.uni-muenster.de>

View thread View on postgr.es
From: Christian Breimann <chr@math.uni-muenster.de>
To: pgsql-bugs@postgresql.org
Date: 2001-05-10T08:25:10Z
Lists: pgsql-bugs 
Hello,

I think, that I've found one bug in PostgreSQL 7.1 on
sparc-sun-Solaris2.7, compilied by GCC 2.7.2.3:


When executing a SQL-Query with a "where not exists (...)" Statement,
the result is wrong. It's the same result as I execute "where exists
(...)" This mustn't be true.

Is this a known bug?

Greetings

Christian Breimann

-- 
Christian Breimann
chr@math.uni-muenster.de       Institut fuer Informatik
Tel.: (+49) 251 - 83 38442     Westfaelische Wilhelms-Universitaet
FAX.: (+49) 251 - 83 33755     Einsteinstr. 62, 48149 Muenster, Germany