From ed5003c58401e5727fcdd970505972394c95febb Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 12 Sep 2000 21:07:18 +0000 Subject: First cut at full support for OUTER JOINs. There are still a few loose ends to clean up (see my message of same date to pghackers), but mostly it works. INITDB REQUIRED! --- src/backend/parser/parse_agg.c | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'src/backend/parser/parse_agg.c') diff --git a/src/backend/parser/parse_agg.c b/src/backend/parser/parse_agg.c index bbc8f5c7076..955be022e4e 100644 --- a/src/backend/parser/parse_agg.c +++ b/src/backend/parser/parse_agg.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/parser/parse_agg.c,v 1.39 2000/07/17 03:05:02 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/parser/parse_agg.c,v 1.40 2000/09/12 21:07:02 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -152,6 +152,11 @@ parseCheckAggregates(ParseState *pstate, Query *qry) */ if (contain_agg_clause(qry->qual)) elog(ERROR, "Aggregates not allowed in WHERE clause"); + /* + * ON-conditions in JOIN expressions are like WHERE clauses. + */ + if (contain_agg_clause((Node *) qry->jointree)) + elog(ERROR, "Aggregates not allowed in JOIN conditions"); /* * No aggregates allowed in GROUP BY clauses, either. -- cgit v1.2.3