Postgres Pro
Downloads
Home   >   mailing lists

Re: I probably don't understand aggregates. - Mailing list pgsql-novice

From David G Johnston
Subject Re: I probably don't understand aggregates.
Date
Msg-id CAKFQuwZJDDXmaDNzH5VuDS5+nmkPxTgZfXO60K5jW25yqdLEug@mail.gmail.com
Whole thread Raw
In response to Re: I probably don't understand aggregates.  (Markus Neumann <markus@neumann.ch>)
Responses Re: I probably don't understand aggregates.  (Markus Neumann <markus.neumann@math.uzh.ch>)
List pgsql-novice
Tree view

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.

pgsql-novice by date:

Previous
From: Markus Neumann
Date:
Subject: Re: I probably don't understand aggregates.
Next
From: Markus Neumann
Date:
Subject: Re: I probably don't understand aggregates.