Re: Aggregate ORDER BY patch - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Aggregate ORDER BY patch
Date
Msg-id 407d949e0911130142l12c98732w3aa7d1d4a63d3642@mail.gmail.com
Whole thread Raw
In response to Re: Aggregate ORDER BY patch  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Aggregate ORDER BY patch
List pgsql-hackers
On Fri, Nov 13, 2009 at 7:54 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> Andrew Gierth wrote:
>> Herewith a patch to implement agg(foo ORDER BY bar) with or without
>> DISTINCT, etc.
>
> What does that mean? Aggregate functions are supposed to be commutative,
> right?

We certainly have non-commutative agggregates currently, notably array_agg()

I suspect it would be good to have a flag marking the commutative ones


-- 
greg


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Check constraint on domain over an array not executed for array literals
Next
From: Joachim Wieland
Date:
Subject: Re: Listen / Notify rewrite