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 1225122443.1375.23.camel@jdavis
Whole thread Raw
In response to Re: array_agg and array_accum (patch)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, 2008-10-26 at 23:02 -0400, Tom Lane wrote:
> "Ian Caulfield" <ian.caulfield@gmail.com> writes:
> > I think array_agg also keeps nulls - although the draft standard I
> > have seems to contradict itself about this...
> 
> The SQL:2008 draft I have says, in 10.9 <aggregate function> general
> rule 8g
> 

I apologize, clearly I skimmed the standard too fast.

I'll review the standard, allow array_agg() to collect NULLs, perhaps
drop array_accum (if the only difference is the return value on no
input), and resubmit with docs.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot Standby utility and administrator functions
Next
From: Tom Lane
Date:
Subject: Re: ERRORDATA_STACK_SIZE exceeded (server crash)