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: 3AFA5066.F851227B@math.uni-muenster.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(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

Responses

Browse pgsql-bugs by date

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