Re: A fine point about OUTER JOIN semantics - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A fine point about OUTER JOIN semantics
Date
Msg-id 1206.967912858@sss.pgh.pa.us
Whole thread Raw
In response to Re: A fine point about OUTER JOIN semantics  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> In some cases, an outer join with WHERE restrictions reduces to
> an inner join (so the qualification clauses can be consolidated).

I recall you having muttered something about that before, but I don't
see how it works.  Can you give an example of an outer join that
reduces to an inner join?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: (Slightly) broken makefiles
Next
From: Alfred Perlstein
Date:
Subject: Really bad/weird stuff with views over tables in 7.0.2