Re: Aggregation ordering with GROUP BY - Mailing list pgsql-general

From Tom Lane
Subject Re: Aggregation ordering with GROUP BY
Date
Msg-id 17746.1123730289@sss.pgh.pa.us
Whole thread Raw
In response to Aggregation ordering with GROUP BY  (Thomas Schoen <t.schoen@vitrado.de>)
List pgsql-general
Thomas Schoen <t.schoen@vitrado.de> writes:
> Now, finally, my questions are:
> - Is there any guaranty, that two aggregates in a GROUP BY statement are
> aggregated in the same order?
> - If yes: is there any guaranty the behaviour won't change in future
> versions of PG. (I suppose SQL-standard doesn't make any statement about
> how the behaviour should be here.)

No, the spec doesn't promise anything, and so we don't either.  In
practice though I find it hard to visualize why the implementation would
not process all the aggregates in parallel.

            regards, tom lane

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: EnterpriseDB mentioned in eweek, and...
Next
From: William Bug
Date:
Subject: Re: Inheritance vs. LIKE - need advice