Sort and uniq example in PostgreSQL with intarray extension.

sort_and_uniq_example.sql

CREATE EXTENSION intarray;

SELECT uniq(sort(ARRAY[3,2,1,4,3]));
--    uniq
-- -----------
-- {1,2,3,4}

SELECT unnest(uniq(sort(ARRAY[3,2,1,4,3])));
--  unnest
-- --------
--       1
--       2
--       3
--       4