Re: ERROR: ExecEvalAggref: no aggregates in this expression context

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul McGarry <paulm(at)opentec(dot)com(dot)au>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: ERROR: ExecEvalAggref: no aggregates in this expression context
Date: 2000-07-05 17:15:22
Message-ID: 3397.962817322@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Paul McGarry <paulm(at)opentec(dot)com(dot)au> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-07-05 18:12:37 Re: lztext and compression ratios...
Previous Message Jeffery Collins 2000-07-05 16:59:12 lztext and compression ratios...