Horton

Re: Hack around lack of CORRESPONDING BY in EXCEPT?

Manfred Koizar <mkoi-pg@aon.at>

View thread
From: Manfred Koizar <mkoi-pg@aon.at>
To: "Lucas Adamski" <ladamski@manageww.com>
Cc: "Postgresql Performance Mailing list (E-mail)" <pgsql-performance@postgresql.org>
Date: 2003-05-07T23:54:04Z
Lists: 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