diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-02-15 20:12:41 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-02-15 20:12:41 +0000 |
| commit | 056467ec6bcbd81a9d1480af8d641946a5ef1bff (patch) | |
| tree | 9bcbdc5f6443cc045783a0e712fbab572eff0952 /src/include/optimizer/pathnode.h | |
| parent | 50c4190e370a66bc8c52a0985cebf5560b28b058 (diff) | |
Teach planner how to propagate pathkeys from sub-SELECTs in FROM up to
the outer query. (The implementation is a bit klugy, but it would take
nontrivial restructuring to make it nicer, which this is probably not
worth.) This avoids unnecessary sort steps in examples like
SELECT foo,count(*) FROM (SELECT ... ORDER BY foo,bar) sub GROUP BY foo
which means there is now a reasonable technique for controlling the
order of inputs to custom aggregates, even in the grouping case.
Diffstat (limited to 'src/include/optimizer/pathnode.h')
| -rw-r--r-- | src/include/optimizer/pathnode.h | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/include/optimizer/pathnode.h b/src/include/optimizer/pathnode.h index e842a699b17..6d112a5cf07 100644 --- a/src/include/optimizer/pathnode.h +++ b/src/include/optimizer/pathnode.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: pathnode.h,v 1.49 2003/02/08 20:20:55 tgl Exp $ + * $Id: pathnode.h,v 1.50 2003/02/15 20:12:41 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -41,7 +41,7 @@ extern ResultPath *create_result_path(RelOptInfo *rel, Path *subpath, extern MaterialPath *create_material_path(RelOptInfo *rel, Path *subpath); extern UniquePath *create_unique_path(Query *root, RelOptInfo *rel, Path *subpath); -extern Path *create_subqueryscan_path(RelOptInfo *rel); +extern Path *create_subqueryscan_path(RelOptInfo *rel, List *pathkeys); extern Path *create_functionscan_path(Query *root, RelOptInfo *rel); extern NestPath *create_nestloop_path(Query *root, |