>>>>> "Jeff" == Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> On Sat, 2009-03-28 at 11:57 +0000, Andrew Gierth wrote:
>> The array_agg() does, I believe, match the standard one, at least
>> my reading of the spec doesn't reveal any obvious issues there.
Jeff> I think it's missing the ORDER BY clause.
Hm, yeah, so it is.
Could that be added (not for 8.4, and not necessarily just for
array_agg but for all aggregates) by piggybacking on the existing
DISTINCT mechanism for aggregates?
--
Andrew.