Re: array_agg and array_accum (patch) - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: array_agg and array_accum (patch)
Date
Msg-id 1225682527.1375.150.camel@jdavis
Whole thread Raw
In response to array_agg and array_accum (patch)  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: array_agg and array_accum (patch)
List pgsql-hackers
Here's an updated patch for just array_accum() with some simple docs. If
I should document this in more places, let me know.

I decided not to include array_agg() in this patch because it doesn't
support the standard's ORDER BY clause.

My reasoning is that, if someone is using the standard array_agg() and
porting to PostgreSQL, there's a fairly high chance they would be using
the ORDER BY clause as well, due to the nature of the function. If not,
and they really want a function called array_agg that returns NULL on no
input, it would be trivial to just create an extra final function that
behaved that way and create a new aggregate.

However, if people want me to put array_agg() back in I will.

Regards,
    Jeff Davis

Attachment

pgsql-hackers by date:

Previous
From: "Lawrence, Ramon"
Date:
Subject: Re: Proposed Patch to Improve Performance of Multi-Batch Hash Join for Skewed Data Sets
Next
From: Tom Lane
Date:
Subject: Where to point CommitFestOpen?