diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-12-01 21:05:14 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-12-01 21:05:14 +0000 |
commit | 8e3a87fbd4d5552599888b087e23a28df0bb6be5 (patch) | |
tree | e99856f0fdd38b253a25f9cb0334ad23e576baf5 /src/include | |
parent | 02f8c9a38297459c2664044ea6d98d91678a4d79 (diff) | |
download | postgresql-8e3a87fbd4d5552599888b087e23a28df0bb6be5.tar.gz postgresql-8e3a87fbd4d5552599888b087e23a28df0bb6be5.zip |
Teach planner to expand sufficiently simple SQL-language functions
('SELECT expression') inline, like macros, during the constant-folding
phase of planning. The actual expansion is not difficult, but checking
that we're not changing the semantics of the call turns out to be more
subtle than one might think; in particular must pay attention to
permissions issues, strictness, and volatility.
Diffstat (limited to 'src/include')
-rw-r--r-- | src/include/optimizer/clauses.h | 3 | ||||
-rw-r--r-- | src/include/utils/lsyscache.h | 4 |
2 files changed, 5 insertions, 2 deletions
diff --git a/src/include/optimizer/clauses.h b/src/include/optimizer/clauses.h index 1cf8fbaf839..da0fe4c5102 100644 --- a/src/include/optimizer/clauses.h +++ b/src/include/optimizer/clauses.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: clauses.h,v 1.55 2002/11/06 22:31:24 tgl Exp $ + * $Id: clauses.h,v 1.56 2002/12/01 21:05:14 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -51,6 +51,7 @@ extern void check_subplans_for_ungrouped_vars(Query *query); extern bool contain_mutable_functions(Node *clause); extern bool contain_volatile_functions(Node *clause); +extern bool contain_nonstrict_functions(Node *clause); extern bool is_pseudo_constant_clause(Node *clause); extern List *pull_constant_clauses(List *quals, List **constantQual); diff --git a/src/include/utils/lsyscache.h b/src/include/utils/lsyscache.h index ff88d30e73d..a0d3574b246 100644 --- a/src/include/utils/lsyscache.h +++ b/src/include/utils/lsyscache.h @@ -6,7 +6,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: lsyscache.h,v 1.64 2002/09/19 23:40:56 tgl Exp $ + * $Id: lsyscache.h,v 1.65 2002/12/01 21:05:14 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -31,6 +31,7 @@ extern bool op_mergejoinable(Oid opno, Oid ltype, Oid rtype, extern void op_mergejoin_crossops(Oid opno, Oid *ltop, Oid *gtop, RegProcedure *ltproc, RegProcedure *gtproc); extern Oid op_hashjoinable(Oid opno, Oid ltype, Oid rtype); +extern bool op_strict(Oid opno); extern char op_volatile(Oid opno); extern Oid get_commutator(Oid opno); extern Oid get_negator(Oid opno); @@ -39,6 +40,7 @@ extern RegProcedure get_oprjoin(Oid opno); extern char *get_func_name(Oid funcid); extern Oid get_func_rettype(Oid funcid); extern bool get_func_retset(Oid funcid); +extern bool func_strict(Oid funcid); extern char func_volatile(Oid funcid); extern Oid get_relname_relid(const char *relname, Oid relnamespace); extern Oid get_system_catalog_relid(const char *catname); |