aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2002-06-13 15:10:25 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2002-06-13 15:10:25 +0000
commitf67a931aa42a28b44c12bed603365686101cfa0e (patch)
tree7abadd9a50769ea7f8f7f118dea07da4d09d9fa3 /src
parentb1ac89f594114a8ff4b6f9dab1648c816d0c36b0 (diff)
downloadpostgresql-f67a931aa42a28b44c12bed603365686101cfa0e.tar.gz
postgresql-f67a931aa42a28b44c12bed603365686101cfa0e.zip
Make WHERE conditions pulled up from subqueries be executed before outer
WHERE conditions, if there is no reason to do it differently.
Diffstat (limited to 'src')
-rw-r--r--src/backend/optimizer/plan/planner.c4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/optimizer/plan/planner.c b/src/backend/optimizer/plan/planner.c
index a28c088e8fa..7e1c7ffdc00 100644
--- a/src/backend/optimizer/plan/planner.c
+++ b/src/backend/optimizer/plan/planner.c
@@ -8,7 +8,7 @@
*
*
* IDENTIFICATION
- * $Header: /cvsroot/pgsql/src/backend/optimizer/plan/planner.c,v 1.119 2002/05/18 18:49:41 tgl Exp $
+ * $Header: /cvsroot/pgsql/src/backend/optimizer/plan/planner.c,v 1.120 2002/06/13 15:10:25 tgl Exp $
*
*-------------------------------------------------------------------------
*/
@@ -656,7 +656,7 @@ preprocess_jointree(Query *parse, Node *jtnode)
if (childlen <= 1 || (childlen + myothers) <= geqo_rels / 2)
{
newlist = nconc(newlist, subf->fromlist);
- f->quals = make_and_qual(f->quals, subf->quals);
+ f->quals = make_and_qual(subf->quals, f->quals);
}
else
newlist = lappend(newlist, child);