Re: IN, EXISTS or ANY?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: IN, EXISTS or ANY?
Date: 2002-04-29 05:24:53
Message-ID: web-1387410@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joseph Barillari 2002-04-29 06:20:00 Temporary table weirdness
Previous Message Tom Lane 2002-04-29 04:54:23 Re: IN, EXISTS or ANY?