confusing error message

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: confusing error message
Date: 2013-08-08 01:35:10
Message-ID: 1375925710.17807.13.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm having trouble parsing this:

ERROR: aggregate functions are not allowed in FROM clause of their own query level

The example in the regression tests is:

-- LATERAL can be used to put an aggregate into the FROM clause of its query
select 1 from tenk1 a, lateral (select max(a.unique1) from int4_tbl b) ss;
ERROR: aggregate functions are not allowed in FROM clause of their own query level
LINE 1: select 1 from tenk1 a, lateral (select max(a.unique1) from i...
^
I think the "own query level" of the max aggregate function in this case
is the subquery "ss", and so it's not in the FROM clause of its own
query level.

It's understandable why this is not allowed, but I don't think the error
message explains it. Could we come up with a better wording?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2013-08-08 01:55:14 timeline signedness
Previous Message Peter Eisentraut 2013-08-08 01:25:06 MultiXactId concept underdocumented