Thread: pgsql-server/src backend/optimizer/plan/planne ...

pgsql-server/src backend/optimizer/plan/planne ...

From
tgl@postgresql.org (Tom Lane)
Date:
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@postgresql.org    03/02/09 18:57:19

Modified files:
    src/backend/optimizer/plan: planner.c
    src/backend/optimizer/prep: prepjointree.c
    src/include/optimizer: prep.h

Log message:
    Detect case where an outer join can be reduced to a plain inner join
    because there are WHERE clauses that will reject the null-extended rows.
    Per suggestion from Brandon Craig Rhodes, 19-Nov-02.