Horton

Re: IN, EXISTS or ANY?

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: "Josh Berkus" <josh@agliodbs.com>
To: Keith Gray <keith@heart.com.au>, pgsql-sql@postgresql.org
Date: 2002-10-09T03:53:12Z
Lists: pgsql-sql 
Keith,

> >>But EXISTS is an entirely different animal which is often faster
> >>... isn't that in the FAQ?
> 
> 
> There is no reference to EXISTS in the SELECT documentation??
> 
> Is this explained somewhere else?

Hmmm ....  found this using the Index for the online docs:

http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/functions-subquery.html

Have fun.

-Josh