On Sep 1, 2010, at 11:09 AM, Pavel Stehule wrote:
> Then you can eliminate NULLs with simple function
>
> CREATE OR REPLACE FUNCTION remove_null(anyarray)
> RETURNS anyarray AS $$
> SELECT ARRAY(SELECT x FROM unnest($1) g(x) WHERE x IS NOT NULL)
> $$ LANGUAGE sql;
Kind of defeats the purpose of the efficiency of the aggregate.
Best,
David