>>>>> "Heikki" == Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> >>>>> writes:
>> Herewith a patch to implement agg(foo ORDER BY bar) with or >> without DISTINCT, etc. Heikki> What does that mean? Aggregate functions are supposed to be Heikki> commutative, right? The SQL spec defines two non-commutative aggregates that we implement: array_agg(x ORDER BY ...) xmlagg(x ORDER BY ...) In addition, of course, we allow user-defined aggregates, which are perfectly free to be non-commutative. -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
