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

exists <==> not exists ???

From: Christian Breimann <chr(at)math(dot)uni-muenster(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: exists <==> not exists ???
Date: 2001-05-10 08:25:10
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs

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

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?


Christian Breimann

Christian Breimann
chr(at)math(dot)uni-muenster(dot)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

Next:From: McCoy MunDate: 2001-05-10 09:33:54
Subject: createdb test shown as number in data directory
Previous:From: Jerome O'NeilDate: 2001-05-10 08:13:42
Subject: RE: SELECT updatability clause defective.

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