Re: IN vs EXISTS equivalence

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Kevin Grittner" <Kgrittn(dot)CCAP(dot)Courts(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: IN vs EXISTS equivalence
Date: 2007-10-23 06:04:17
Message-ID: 162867790710222304s7a3518e6j9369d8ae4f90e79b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2007/10/23, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>:
> >>> On Mon, Oct 22, 2007 at 4:37 PM, in message
> <471CD1BE(dot)EE98(dot)0025(dot)0(at)wicourts(dot)gov>, "Kevin Grittner"
> <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>
> > One more logically equivalent, PostgreSQL-specific form which
> > costs out even better was suggested off-list:
>
> Oops. That is not logically equivalent. We want to delete WHERE NOT
> EXISTS; the logic of that suggestion is backwards.
>
> Disregard that last post, please.
>
> -Kevin
>
>
my mistake, sorry

Pavel

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2007-10-23 07:03:53 Re: Feature Freeze date for 8.4
Previous Message Greg Smith 2007-10-23 05:55:47 Re: Feature Freeze date for 8.4