SELECT ARRAY(SELECT DISTINCT e FROM unnest(ARRAY[a,b,c,d]) AS a(e))<br /> FROM ( VALUES<br /> (‘foo’, ‘bar’, ‘foo’, ‘baz’ )<br /> ) AS t(a,b,c,d);

SELECT ARRAY(SELECT DISTINCT unnest(t_column)) FROM t_name;