On 08/28/2014 03:46 AM, Claudio Freire wrote:
> You can't with mean and stddev, only with associative aggregates.
>
> That's min, max, sum, bit_and, bit_or, bool_and, bool_or, count.
You could with a new helper function to merge the temporary states for
each scan though.
In the case of mean, for example, it'd just mean adding the counts and sums.
However, I'm not sure how interesting that is without the ability to
execute the subplans in parallel.
-- Craig Ringer http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services