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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: ExecEvalAggref: no aggregates in this expression context
Дата
Msg-id 3397.962817322@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ERROR: ExecEvalAggref: no aggregates in this expression context  (Paul McGarry <paulm@opentec.com.au>)
Список pgsql-sql
Paul McGarry <paulm@opentec.com.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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "omid omoomi"
Дата:
Сообщение: Re: Median
Следующее
От: Paul McGarry
Дата:
Сообщение: Re: ERROR: ExecEvalAggref: no aggregates in this expressioncontext