diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-03-18 22:04:14 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-03-18 22:04:14 +0000 |
| commit | 0d49838df6f54c5b49d40a8cf396ea799bd3c4d9 (patch) | |
| tree | 10bc9771479d02eb22a9a2fcec20e758ad5715bb /src/include/optimizer/prep.h | |
| parent | 433c5238bf1980b917b758f3003f16f134c34540 (diff) | |
| download | postgresql-0d49838df6f54c5b49d40a8cf396ea799bd3c4d9.tar.gz | |
Arrange to "inline" SQL functions that appear in a query's FROM clause,
are declared to return set, and consist of just a single SELECT. We
can replace the FROM-item with a sub-SELECT and then optimize much as
if we were dealing with a view. Patch from Richard Rowell, cleaned up
by me.
Diffstat (limited to 'src/include/optimizer/prep.h')
| -rw-r--r-- | src/include/optimizer/prep.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/include/optimizer/prep.h b/src/include/optimizer/prep.h index b98040a498..80fa3b5152 100644 --- a/src/include/optimizer/prep.h +++ b/src/include/optimizer/prep.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/optimizer/prep.h,v 1.59 2008/01/01 19:45:58 momjian Exp $ + * $PostgreSQL: pgsql/src/include/optimizer/prep.h,v 1.60 2008/03/18 22:04:14 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -22,6 +22,7 @@ * prototypes for prepjointree.c */ extern Node *pull_up_IN_clauses(PlannerInfo *root, Node *node); +extern void inline_set_returning_functions(PlannerInfo *root); extern Node *pull_up_subqueries(PlannerInfo *root, Node *jtnode, bool below_outer_join, bool append_rel_member); extern void reduce_outer_joins(PlannerInfo *root); |