Re: I probably don't understand aggregates.

Поиск
Список
Период
Сортировка
От Markus Neumann
Тема Re: I probably don't understand aggregates.
Дата
Msg-id 5398DCBD.3000409@math.uzh.ch
обсуждение исходный текст
Ответ на Re: I probably don't understand aggregates.  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-novice
On 12.06.2014 00:34, David G Johnston wrote:

But how can I get my wrapper function to evaluate the aggregate on the
whole table and work with the result afterwards?

Or do I need to change the aggregate?


​I do not follow but...

SELECT myWrapper(agg_output) FROM (
SELECT myAgg(x) AS agg_output FROM test
)​ agg_subquery;

It is not clear why you need both an aggregate and a wrapper...

David J.



View this message in context: Re: I probably don't understand aggregates.
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

That explains and solves my problem.

Thanks a lot and good night.

Markus

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

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: I probably don't understand aggregates.
Следующее
От: ssharma
Дата:
Сообщение: Re: Need help with this Function. I'm getting an error