Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Doc: improve example for intarray's uniq() function.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 3 Jun 2022 17:54:53 +0000 (13:54 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 3 Jun 2022 17:55:03 +0000 (13:55 -0400)
The previous entry invited confusion between what uniq() does
by itself and what it does when combined with sort().  The latter
usage is pretty useful so we should show it, but add an additional
example to clarify the results of uniq() alone.

Per suggestion from Martin Kalcher.  Back-patch to v13, where
we switched to formatting that supports multiple examples.

Discussion: https://postgr.es/m/165407884456.573551.8779012279828726162@wrigleys.postgresql.org

doc/src/sgml/intarray.sgml

index fdeedc6409e187edf55cfbc3e2c278dca6c904c7..3f7ee309e228aaf51eb2dc8deaf25bf6f241c855 100644 (file)
        </para>
        <para>
         Removes adjacent duplicates.
+        Often used with <function>sort</function> to remove all duplicates.
+       </para>
+       <para>
+        <literal>uniq('{1,2,2,3,1,1}'::integer[])</literal>
+        <returnvalue>{1,2,3,1}</returnvalue>
        </para>
        <para>
         <literal>uniq(sort('{1,2,3,2,1}'::integer[]))</literal>