Re: Except without elimination of non-distinct rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ray Madigan" <ray(at)madigans(dot)org>
Cc: "Pgsql-Sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Except without elimination of non-distinct rows
Date: 2008-02-05 02:19:43
Message-ID: 11918.1202177983@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Ray Madigan" <ray(at)madigans(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ray Madigan 2008-02-05 03:23:03 Re: Except without elimination of non-distinct rows
Previous Message Ray Madigan 2008-02-05 02:16:07 Except without elimination of non-distinct rows