CODE EXAMPLE FOR SQL

postgresql make each element in array distinct

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