Re: I probably don't understand aggregates.

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

In response to

Browse pgsql-novice by date

  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.