Re: Hack around lack of CORRESPONDING BY in EXCEPT?

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "Lucas Adamski" <ladamski(at)manageww(dot)com>
Cc: "Postgresql Performance Mailing list (E-mail)" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hack around lack of CORRESPONDING BY in EXCEPT?
Date: 2003-05-07 23:54:04
Message-ID: c46jbvsvtaaci4qmvl93m4mokeln7ebcd8@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 7 May 2003 15:49:06 -0700, "Lucas Adamski"
<ladamski(at)manageww(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-05-08 04:13:20 Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.
Previous Message Randall Lucas 2003-05-07 23:52:30 Re: [SQL] Unanswered Questions WAS: An unresolved performance problem.