Horton

Re: exists <==> not exists ???

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christian Breimann <chr@math.uni-muenster.de>
Cc: pgsql-bugs@postgresql.org
Date: 2001-05-11T13:35:00Z
Lists: pgsql-bugs 
Christian Breimann <chr@math.uni-muenster.de> writes:
> 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.

This is a completely unhelpful bug report.  We need sufficient details
to let us reproduce the problem.

			regards, tom lane