Re: TODO item - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: TODO item
Date
Msg-id 1238266531.17035.38.camel@jdavis
Whole thread Raw
In response to Re: TODO item  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Solaris getopt_long and PostgreSQL
Next
From: Josh Berkus
Date:
Subject: Re: Should SET ROLE inherit config params?