Postgres Pro
Downloads
Home   >   mailing lists

ERROR: aggregate function calls cannot be nested - Mailing list pgsql-general

From Jonathan Blitz
Subject ERROR: aggregate function calls cannot be nested
Date
Msg-id EC17050DB4D1428983F92C872D616D6F@jblaptop
Whole thread Raw
Responses Re: ERROR: aggregate function calls cannot be nested  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Updating column on row update
Next
From: silly8888
Date:
Subject: Re: Updating column on row update