On Sun, 2008-10-26 at 23:02 -0400, Tom Lane wrote: > "Ian Caulfield" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers