Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1916: selection criteria from one outer join on clause applied to other joins - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1916: selection criteria from one outer join on clause applied to other joins
Date
Msg-id 1909.1127882077@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1916: selection criteria from one outer join on clause applied to other joins  ("Kevin Grittner" <kevin.grittner@wicourts.gov>)
Responses Re: BUG #1916: selection criteria from one outer join on clause applied to other joins  (Klint Gore <kg@kgb.une.edu.au>)
List pgsql-bugs
Tree view 
"Kevin Grittner" <kevin.grittner@wicourts.gov> writes:
> Obviously, adding an outer join to a query which is already returning rows
> should never reduce the number of rows returned.

I think this is a case of overenthusiastic propagation of implied
equalities.  Do you know offhand if it fails in 8.0.* or earlier
branches?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: BUG #1916: selection criteria from one outer join on clause applied to other joins
Next
From: Klint Gore
Date:
Subject: Re: BUG #1916: selection criteria from one outer join on clause applied to other joins