Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 502B52E3430 for ; Mon, 4 Feb 2008 22:13:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17010-04 for ; Mon, 4 Feb 2008 22:13:43 -0400 (AST) Received: from n054.sc0.he.tucows.com (smtpout1070.sc0.he.tucows.com [64.97.144.70]) by postgresql.org (Postfix) with ESMTP id 7295F2E033E for ; Mon, 4 Feb 2008 22:13:43 -0400 (AST) Received: from sc0-out09.emaildefenseservice.com (64.97.131.2) by n054.sc0.he.tucows.com (7.2.069.1) id 476BFC7B00B97CBC for pgsql-sql@postgresql.org; Tue, 5 Feb 2008 02:13:41 +0000 X-SpamScore: 2 X-Spamcatcher-Summary: 2, 0, 0, 302b8355d8d162e7, 9f09eb6bff01d9ba, ray@madigans.org, -, RULES_HIT:355:379:539:540:541:542:543:968:988:989:1253:1260:1277:1297:1298:1311:1313:1314:1345:1437:1515:1516:1518:1534:1536:1559:1587:1593:1594:1711:1714:1730:1747:1766:1792:2393:2559:2562:2828:3865:3866:3867:3871:3874:5007:6261, 0, RBL:none, CacheIP:none, Bayesian:0.5, 0.5, 0.5, Netcheck:none, DomainCache:0, MSF:not bulk, SPF:, MSBL:none, DNSBL:none X-Spamcatcher-Explanation: Received: from dreamland (unknown [74.94.66.41]) (Authenticated sender: ray@madigans.org) by sc0-out09.emaildefenseservice.com (Postfix) with ESMTP for ; Tue, 5 Feb 2008 02:13:40 +0000 (UTC) From: "Ray Madigan" To: "Pgsql-Sql" Subject: Except without elimination of non-distinct rows Date: Mon, 4 Feb 2008 18:16:07 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.524 tagged_above=0 required=5 tests=AWL=-1.476, BAYES_80=2 X-Spam-Level: X-Archive-Number: 200802/11 X-Sequence-Number: 30102 Is there any way to use except that won't remove the non-distinct rows from the left side of the query?