summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2022-06-03 13:54:53 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2022-06-03 13:55:03 -0400
commit9985139046c3aad4214cdd490e7bcdfefc9290d3 (patch)
tree455876c71caabddf5fb12a460f10eecd49875e76
parent54299b9ce7ccea885c06d6833ec04b3b06a82788 (diff)
Doc: improve example for intarray's uniq() function.
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
-rw-r--r--doc/src/sgml/intarray.sgml5
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/intarray.sgml b/doc/src/sgml/intarray.sgml
index fdeedc6409e..3f7ee309e22 100644
--- a/doc/src/sgml/intarray.sgml
+++ b/doc/src/sgml/intarray.sgml
@@ -131,6 +131,11 @@
</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>