Returns an array with no NULL or '' (emtpy string) values

array_filter_blanks.sql

CREATE OR REPLACE FUNCTION array_filter_blanks(
	ANYARRAY
)
RETURNS ANYARRAY
LANGUAGE sql
IMMUTABLE
STRICT
AS $$

	SELECT ARRAY(
		SELECT x
		FROM UNNEST( $1 ) AS x
		WHERE x IS NOT NULL
		AND x <> ''
	);

$$;