The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/intarray.html Description:
The **uniq** function in the **intarray** extension removes **adjacent** duplicates from an integer array. The documentation[0] about this behavior is correct, but the example is a bit misleading, because it sorts the array before applying uniq. The sort can be overlooked **easily** and leads to the impression that **uniq** removes all duplicates from the array. I propse to change the example to somthing like that: uniq('{1,2,2,3,1,1}'::integer[]) → {1,2,3,1} It might be a good idea to refer to the **sort** function in case one wants to remove all duplicates. Cheers, Martin Kalcher [0] https://www.postgresql.org/docs/current/intarray.html#INTARRAY-FUNC-TABLE