Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
[GENERAL] ERROR: aggregate function calls cannot be nested
146 views
Skip to first unread message
Jonathan Blitz
Nov 22, 2009, 7:14:04 PM11/22/09
to
Hi,
I
am getting the message 'ERROR: aggregate function calls cannot be nested" when
using a select from an inner select.
The outer select had a group by clause but the inner
one is a straight join between a few tables.
What exactly does this message
mean?
Jonathan Blitz
Tom Lane
Nov 22, 2009, 7:33:32 PM11/22/09
to
Jonathan Blitz <jbl...@013.net> writes:
> What exactly does this message mean?
> What exactly does this message mean?
It means you can't write something like avg(sum(x)).
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
0 new messages