Re: IN, EXISTS or ANY?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Keith Gray <keith(at)heart(dot)com(dot)au>, pgsql-sql(at)postgresql(dot)org
Subject: Re: IN, EXISTS or ANY?
Date: 2002-10-09 03:53:12
Message-ID: web-1776493@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-10-09 04:45:12 Re: Temporary tables and indexes
Previous Message Keith Gray 2002-10-09 00:51:54 Re: IN, EXISTS or ANY?