Hi, During reviewing aggregates ORDER BY, I was reading spec and found description like:
== snip == Of the rows in the aggregation, the following do not qualify: — If DISTINCT is specified, then redundant duplicates. — Every row in which the <value expression> evaluates to the null value. == /snip == ... and array_agg() is among the functions that description above refers to. So I wonder if array_agg doesn't accept NULL input (with STRICT trans function). Did we discussed about this issue when implementing it for 8.4? Regards, -- Hitoshi Harada -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
