Re: IN, EXISTS or ANY? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: IN, EXISTS or ANY?
Date
Msg-id web-1387410@davinci.ethosmedia.com
Whole thread Raw
In response to Re: IN, EXISTS or ANY?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: IN, EXISTS or ANY?
Next
From: Joseph Barillari
Date:
Subject: Temporary table weirdness