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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers