Re: Hack around lack of CORRESPONDING BY in EXCEPT? - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: Hack around lack of CORRESPONDING BY in EXCEPT?
Date
Msg-id c46jbvsvtaaci4qmvl93m4mokeln7ebcd8@4ax.com
Whole thread Raw
In response to Re: Hack around lack of CORRESPONDING BY in EXCEPT?  ("Lucas Adamski" <ladamski@manageww.com>)
List pgsql-performance
On Wed, 7 May 2003 15:49:06 -0700, "Lucas Adamski"
<ladamski@manageww.com> wrote:
>The problem is that it simply removes all events where type != 10, versus
>subtracting all events from subselect of type 10 where data1 and data2 match
>those in the main join.

Yes, I realized it when I read Stephan's comment immediately after I
had sent my mail.  Should have read your requirements more thoroughly.
Sorry for the noise ...

Servus
 Manfred


pgsql-performance by date:

Previous
From: Randall Lucas
Date:
Subject: Re: [SQL] Unanswered Questions WAS: An unresolved performance problem.
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Unanswered Questions WAS: An unresolved performance problem.