Horton

Re: IN, EXISTS or ANY?

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: "Josh Berkus" <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, "Josh Berkus" <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Date: 2002-04-29T05:24:53Z
Lists: pgsql-sql 
Tom,

> But EXISTS is an entirely different animal which is often faster
> ... isn't that in the FAQ?

OK, still true, then hey?  So for subqueries where I expect a
medium-to-large result set, I should use EXISTS.  Got it.

BTW, just tried the new CURSOR implementation for PL/pgSQL for the
first time.  Nice work, guys!

-Josh