pgsql: Arrange to "inline" SQL functions that appear in a query's FROM

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Arrange to "inline" SQL functions that appear in a query's FROM
Date: 2008-03-18 22:04:14
Message-ID: 20080318220414.F402A7558DC@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
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.

Modified Files:
--------------
pgsql/src/backend/catalog:
pg_proc.c (r1.148 -> r1.149)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c?r1=1.148&r2=1.149)
pgsql/src/backend/executor:
functions.c (r1.120 -> r1.121)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/functions.c?r1=1.120&r2=1.121)
pgsql/src/backend/optimizer/plan:
planner.c (r1.226 -> r1.227)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.226&r2=1.227)
pgsql/src/backend/optimizer/prep:
prepjointree.c (r1.49 -> r1.50)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepjointree.c?r1=1.49&r2=1.50)
pgsql/src/backend/optimizer/util:
clauses.c (r1.254 -> r1.255)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c?r1=1.254&r2=1.255)
pgsql/src/include/executor:
functions.h (r1.30 -> r1.31)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/functions.h?r1=1.30&r2=1.31)
pgsql/src/include/optimizer:
clauses.h (r1.88 -> r1.89)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/clauses.h?r1=1.88&r2=1.89)
prep.h (r1.59 -> r1.60)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/prep.h?r1=1.59&r2=1.60)

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2008-03-18 22:07:05 Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that
Previous Message Heikki Linnakangas 2008-03-18 21:54:30 Re: Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one