ERROR: aggregate function calls cannot be nested

От:

Jonathan Blitz <jblitz@013.net>

Дата:

22 ноября 2009 г. в 20:14:36

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 <tgl@sss.pgh.pa.us>

Дата:

22 ноября 2009 г. в 20:33:45

Jonathan Blitz  writes:
> What exactly does this message mean?

It means you can't write something like avg(sum(x)).

			regards, tom lane