Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e65HFqS74093 for ; Wed, 5 Jul 2000 13:15:53 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id NAA03400; Wed, 5 Jul 2000 13:15:22 -0400 (EDT) To: Paul McGarry cc: pgsql-sql@hub.org Subject: Re: ERROR: ExecEvalAggref: no aggregates in this expression context In-reply-to: <3962834C.5EF48AB7@opentec.com.au> References: <200007042201.e64M1GS36467@hub.org> <3962834C.5EF48AB7@opentec.com.au> Comments: In-reply-to Paul McGarry message dated "Wed, 05 Jul 2000 10:37:32 +1000" Date: Wed, 05 Jul 2000 13:15:22 -0400 Message-ID: <3397.962817322@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200007/50 Paul McGarry writes: > Can someone tell me what this error message means: > ERROR: ExecEvalAggref: no aggregates in this expression context > Does it mean that there aren't any aggregate in the expression > context when there should be. Yup. ExecEvalAggref is supposed to fetch the result of a (previously computed) aggregate function. It's unhappy because it's not finding anything to return. This is a bug --- can we see a complete example that causes it? > For that matter, what are aggregates SUM(), COUNT(), MIN(), that sort of thing... regards, tom lane