Postgres Pro
Downloads
Home   >   mailing lists

exists <==> not exists ??? - Mailing list pgsql-bugs

From Christian Breimann
Subject exists <==> not exists ???
Date
Msg-id 3AFA5066.F851227B@math.uni-muenster.de
Whole thread Raw
Responses Re: exists <==> not exists ???
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "McCoy Mun"
Date:
Subject: createdb test shown as number in data directory
Next
From: Palle Girgensohn
Date:
Subject: Re: freebsd sample startup script doesn't work