Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id E54B72E2E77
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  4 Feb 2008 22:19:49 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 63471-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  4 Feb 2008 22:19:39 -0400 (AST)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id F1BFC2E2E74
	for <pgsql-sql@postgresql.org>; Mon,  4 Feb 2008 22:19:46 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m152JiR2011919;
	Mon, 4 Feb 2008 21:19:44 -0500 (EST)
To: "Ray Madigan" <ray@madigans.org>
cc: "Pgsql-Sql" <pgsql-sql@postgresql.org>
Subject: Re: Except without elimination of non-distinct rows 
In-reply-to: <IIEPJABILGOCODDLDNJFCEPECGAA.ray@madigans.org> 
References: <IIEPJABILGOCODDLDNJFCEPECGAA.ray@madigans.org>
Comments: In-reply-to "Ray Madigan" <ray@madigans.org>
	message dated "Mon, 04 Feb 2008 18:16:07 -0800"
Date: Mon, 04 Feb 2008 21:19:43 -0500
Message-ID: <11918.1202177983@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/12
X-Sequence-Number: 30103

"Ray Madigan" <ray@madigans.org> writes:
> Is there any way to use except that won't remove the non-distinct rows from
> the left side of the query?

EXCEPT ALL might or might not do what you're hoping for.  Check the
manual (I think the SELECT reference page is what to look at).

			regards, tom lane