X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7C94F475EC9 for ; Wed, 7 May 2003 19:54:13 -0400 (EDT) Received: from email02.aon.at (WARSL401PIP7.highway.telekom.at [195.3.96.94]) by postgresql.org (Postfix) with SMTP id 7A06D475B8E for ; Wed, 7 May 2003 19:54:12 -0400 (EDT) Received: (qmail 50174 invoked from network); 7 May 2003 23:54:14 -0000 Received: from m170p003.dipool.highway.telekom.at (HELO cantor) ([62.46.11.35]) (envelope-sender ) by qmail2rs.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 7 May 2003 23:54:14 -0000 From: Manfred Koizar To: "Lucas Adamski" Cc: "Postgresql Performance Mailing list (E-mail)" Subject: Re: Hack around lack of CORRESPONDING BY in EXCEPT? Date: Thu, 08 May 2003 01:54:04 +0200 Message-ID: References: <5npibv8l1090ppjkt17is5ipq26honl1e1@4ax.com> <000a01c314ea$de8c5f30$11f5ec0c@LADAMSKI> In-Reply-To: <000a01c314ea$de8c5f30$11f5ec0c@LADAMSKI> X-Mailer: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-32.2 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_FORTE autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/98 X-Sequence-Number: 1877 On Wed, 7 May 2003 15:49:06 -0700, "Lucas Adamski" 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