]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 433c523) | patch
Arrange to "inline" SQL functions that appear in a query's FROM clause,
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 18 Mar 2008 22:04:14 +0000 (22:04 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 18 Mar 2008 22:04:14 +0000 (22:04 +0000)
commit0d49838df6f54c5b49d40a8cf396ea799bd3c4d9
tree10bc9771479d02eb22a9a2fcec20e758ad5715bbtree | snapshot
parent433c5238bf1980b917b758f3003f16f134c34540commit | diff
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.
src/backend/catalog/pg_proc.c diff | blob | history
src/backend/executor/functions.c diff | blob | history
src/backend/optimizer/plan/planner.c diff | blob | history
src/backend/optimizer/prep/prepjointree.c diff | blob | history
src/backend/optimizer/util/clauses.c diff | blob | history
src/include/executor/functions.h diff | blob | history
src/include/optimizer/clauses.h diff | blob | history
src/include/optimizer/prep.h diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.