diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2000-09-29 18:21:41 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2000-09-29 18:21:41 +0000 |
| commit | 3a94e789f5c9537d804210be3cb26f7fb08e3b9e (patch) | |
| tree | f1eac12405e3c0ded881d7dd7e59cec35b30c335 /src/backend/commands/command.c | |
| parent | 6f64c2e54a0b14154a335249f4dca91a39c61c50 (diff) | |
| download | postgresql-3a94e789f5c9537d804210be3cb26f7fb08e3b9e.tar.gz postgresql-3a94e789f5c9537d804210be3cb26f7fb08e3b9e.zip | |
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!
Diffstat (limited to 'src/backend/commands/command.c')
| -rw-r--r-- | src/backend/commands/command.c | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/src/backend/commands/command.c b/src/backend/commands/command.c index 841806810e4..f072c719759 100644 --- a/src/backend/commands/command.c +++ b/src/backend/commands/command.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/Attic/command.c,v 1.103 2000/09/12 21:06:47 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/Attic/command.c,v 1.104 2000/09/29 18:21:26 tgl Exp $ * * NOTES * The PerformAddAttribute() code, like most of the relation @@ -1135,7 +1135,7 @@ AlterTableAddConstraint(char *relationName, else name="<unnamed>"; - constlist=lcons(constr, NIL); + constlist = makeList1(constr); rel = heap_openr(relationName, AccessExclusiveLock); @@ -1158,10 +1158,11 @@ AlterTableAddConstraint(char *relationName, makeRangeTable(pstate, NULL); rte = addRangeTableEntry(pstate, relationName, NULL, false, true); - addRTEtoJoinTree(pstate, rte); + addRTEtoJoinList(pstate, rte); /* Convert the A_EXPR in raw_expr into an EXPR */ - expr = transformExpr(pstate, constr->raw_expr, EXPR_COLUMN_FIRST); + expr = transformExpr(pstate, constr->raw_expr, + EXPR_COLUMN_FIRST); /* * Make sure it yields a boolean result. @@ -1185,14 +1186,14 @@ AlterTableAddConstraint(char *relationName, /* And fix the opids */ fix_opids(expr); - qual = lcons(expr, NIL); + qual = makeList1(expr); rte = makeNode(RangeTblEntry); rte->relname = relationName; rte->relid = RelationGetRelid(rel); rte->eref = makeNode(Attr); rte->eref->relname = relationName; - rtlist = lcons(rte, NIL); + rtlist = makeList1(rte); /* * Scan through the rows now, making the necessary things |