diff --git a/src/backend/parser/parse_func.c b/src/backend/parser/parse_func.c index f71a682cd6..2bd8683347 100644 --- a/src/backend/parser/parse_func.c +++ b/src/backend/parser/parse_func.c @@ -780,17 +780,6 @@ ParseFuncOrColumn(ParseState *pstate, List *funcname, List *fargs, aggref->aggtransno = -1; aggref->location = location; - /* - * Reject attempt to call a parameterless aggregate without (*) - * syntax. This is mere pedantry but some folks insisted ... - */ - if (fargs == NIL && !agg_star && !agg_within_group) - ereport(ERROR, - (errcode(ERRCODE_WRONG_OBJECT_TYPE), - errmsg("%s(*) must be used to call a parameterless aggregate function", - NameListToString(funcname)), - parser_errposition(pstate, location))); - if (retset) ereport(ERROR, (errcode(ERRCODE_INVALID_FUNCTION_DEFINITION), @@ -844,17 +833,6 @@ ParseFuncOrColumn(ParseState *pstate, List *funcname, List *fargs, errmsg("DISTINCT is not implemented for window functions"), parser_errposition(pstate, location))); - /* - * Reject attempt to call a parameterless aggregate without (*) - * syntax. This is mere pedantry but some folks insisted ... - */ - if (wfunc->winagg && fargs == NIL && !agg_star) - ereport(ERROR, - (errcode(ERRCODE_WRONG_OBJECT_TYPE), - errmsg("%s(*) must be used to call a parameterless aggregate function", - NameListToString(funcname)), - parser_errposition(pstate, location))); - /* * ordered aggs not allowed in windows yet */ diff --git a/src/test/regress/expected/window.out b/src/test/regress/expected/window.out index d78b4c463c..7ac2fb3739 100644 --- a/src/test/regress/expected/window.out +++ b/src/test/regress/expected/window.out @@ -3270,10 +3270,6 @@ SELECT rank() OVER (PARTITION BY four, ORDER BY ten) FROM tenk1; ERROR: syntax error at or near "ORDER" LINE 1: SELECT rank() OVER (PARTITION BY four, ORDER BY ten) FROM te... ^ -SELECT count() OVER () FROM tenk1; -ERROR: count(*) must be used to call a parameterless aggregate function -LINE 1: SELECT count() OVER () FROM tenk1; - ^ SELECT generate_series(1, 100) OVER () FROM empsalary; ERROR: OVER specified, but generate_series is not a window function nor an aggregate function LINE 1: SELECT generate_series(1, 100) OVER () FROM empsalary; diff --git a/src/test/regress/sql/window.sql b/src/test/regress/sql/window.sql index 967b9413de..0f0c2bb622 100644 --- a/src/test/regress/sql/window.sql +++ b/src/test/regress/sql/window.sql @@ -952,8 +952,6 @@ SELECT count(*) OVER w FROM tenk1 WINDOW w AS (ORDER BY unique1), w AS (ORDER BY SELECT rank() OVER (PARTITION BY four, ORDER BY ten) FROM tenk1; -SELECT count() OVER () FROM tenk1; - SELECT generate_series(1, 100) OVER () FROM empsalary; SELECT ntile(0) OVER (ORDER BY ten), ten, four FROM tenk1;