Postgres Pro
Downloads
Home   >   mailing lists

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

From Markus Neumann
Subject Re: I probably don't understand aggregates.
Date
Msg-id 5398DCBD.3000409@math.uzh.ch
Whole thread Raw
In response to Re: I probably don't understand aggregates.  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view
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 by date:

Previous
From: David G Johnston
Date:
Subject: Re: I probably don't understand aggregates.
Next
From: ssharma
Date:
Subject: Re: Need help with this Function. I'm getting an error