diff options
| author | Tom Lane | 2003-02-09 23:57:19 +0000 |
|---|---|---|
| committer | Tom Lane | 2003-02-09 23:57:19 +0000 |
| commit | b5956a2f2291de716415875456a4d85943d42610 (patch) | |
| tree | 2de5e5ca0c8ae6af3141e6d0d8e69879ee38e3fc /src/include/optimizer | |
| parent | 43785a434e0864c994ae55ae2b837be15cebe29b (diff) | |
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.
Diffstat (limited to 'src/include/optimizer')
| -rw-r--r-- | src/include/optimizer/prep.h | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/include/optimizer/prep.h b/src/include/optimizer/prep.h index 103e4630cfa..681d1c2eb1d 100644 --- a/src/include/optimizer/prep.h +++ b/src/include/optimizer/prep.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: prep.h,v 1.36 2003/02/08 20:20:55 tgl Exp $ + * $Id: prep.h,v 1.37 2003/02/09 23:57:19 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -28,7 +28,8 @@ extern int join_collapse_limit; extern Node *pull_up_IN_clauses(Query *parse, Node *node); extern Node *pull_up_subqueries(Query *parse, Node *jtnode, bool below_outer_join); -extern Node *preprocess_jointree(Query *parse, Node *jtnode); +extern void reduce_outer_joins(Query *parse); +extern Node *simplify_jointree(Query *parse, Node *jtnode); extern Relids get_relids_in_jointree(Node *jtnode); extern Relids get_relids_for_join(Query *parse, int joinrelid); |