From 3a94e789f5c9537d804210be3cb26f7fb08e3b9e Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 29 Sep 2000 18:21:41 +0000 Subject: Subselects in FROM clause, per ISO syntax: FROM (SELECT ...) [AS] alias. (Don't forget that an alias is required.) Views reimplemented as expanding to subselect-in-FROM. Grouping, aggregates, DISTINCT in views actually work now (he says optimistically). No UNION support in subselects/views yet, but I have some ideas about that. Rule-related permissions checking moved out of rewriter and into executor. INITDB REQUIRED! --- src/include/optimizer/pathnode.h | 10 +++------- 1 file changed, 3 insertions(+), 7 deletions(-) (limited to 'src/include/optimizer/pathnode.h') diff --git a/src/include/optimizer/pathnode.h b/src/include/optimizer/pathnode.h index 0bf57ef0cc5..e5810a042f2 100644 --- a/src/include/optimizer/pathnode.h +++ b/src/include/optimizer/pathnode.h @@ -1,13 +1,13 @@ /*------------------------------------------------------------------------- * * pathnode.h - * prototypes for pathnode.c, indexnode.c, relnode.c. + * prototypes for pathnode.c, relnode.c. * * * Portions Copyright (c) 1996-2000, PostgreSQL, Inc * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: pathnode.h,v 1.28 2000/09/12 21:07:11 tgl Exp $ + * $Id: pathnode.h,v 1.29 2000/09/29 18:21:40 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -32,6 +32,7 @@ extern IndexPath *create_index_path(Query *root, RelOptInfo *rel, List *restriction_clauses, ScanDirection indexscandir); extern TidPath *create_tidscan_path(RelOptInfo *rel, List *tideval); +extern Path *create_subqueryscan_path(RelOptInfo *rel); extern NestPath *create_nestloop_path(RelOptInfo *joinrel, JoinType jointype, @@ -66,9 +67,4 @@ extern RelOptInfo *get_join_rel(Query *root, RelOptInfo *outer_rel, RelOptInfo *inner_rel, List **restrictlist_ptr); -/* - * prototypes for indexnode.h - */ -extern List *find_relation_indices(Query *root, RelOptInfo *rel); - #endif /* PATHNODE_H */ -- cgit v1.2.3