Daily Shaarli

All links of one day in a single page.

May 4, 2017

postgresql - eliminate duplicate array values in postgres - Stack Overflow

UPDATE table_name SET array_col = ARRAY(SELECT DISTINCT UNNEST(array_col) ORDER BY 1) where array_length(array_col, 1) > 1;