From: | Markus Neumann <markus(dot)neumann(at)math(dot)uzh(dot)ch> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: I probably don't understand aggregates. |
Date: | 2014-06-11 22:48:29 |
Message-ID: | 5398DCBD.3000409@math.uzh.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
> <http://postgresql.1045698.n5.nabble.com/I-probably-don-t-understand-aggregates-tp5806879p5806900.html>
> Sent from the PostgreSQL - novice mailing list archive
> <http://postgresql.1045698.n5.nabble.com/PostgreSQL-novice-f2132464.html>
> at Nabble.com.
That explains and solves my problem.
Thanks a lot and good night.
Markus
From | Date | Subject | |
---|---|---|---|
Next Message | ssharma | 2014-06-11 23:19:23 | Re: Need help with this Function. I'm getting an error |
Previous Message | David G Johnston | 2014-06-11 22:34:02 | Re: I probably don't understand aggregates. |