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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
