Answers for "distinct value from array postgresql"

postgresql make each element in array distinct

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

Posted by: Guest on March-20-2021

array aggre distinct postgres

SELECT ARRAY(SELECT DISTINCT e FROM unnest(ARRAY[a,b,c,d]) AS a(e))
FROM ( VALUES
  ('foo', 'bar', 'foo', 'baz' )
) AS t(a,b,c,d);

Posted by: Guest on February-27-2020

Code answers related to "distinct value from array postgresql"