"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