Re: TODO item

On Sat, 2009-03-28 at 15:35 +0000, Andrew Gierth wrote:
> >>>>> "Jeff" == Jeff Davis <pgsql@j-davis.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?

I'm sure it's possible, but it seems like a significant amount of work.
I don't feel very strongly about it myself, because, as I said, it can
be worked around using an ORDER BY in a subselect.

Regards,Jeff Davis