Postgres Pro
Downloads
Home   >   mailing lists

Re: Except without elimination of non-distinct rows - Mailing list pgsql-sql

From Tom Lane
Subject Re: Except without elimination of non-distinct rows
Date
Msg-id 11918.1202177983@sss.pgh.pa.us
Whole thread Raw
In response to Except without elimination of non-distinct rows  ("Ray Madigan" <ray@madigans.org>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: "Ray Madigan"
Date:
Subject: Except without elimination of non-distinct rows
Next
From: "Ray Madigan"
Date:
Subject: Re: Except without elimination of non-distinct rows