postgres.git / summary / log / commit / refs
commit 9985139046c3aad4214cdd490e7bcdfefc9290d3
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Fri Jun 03 17:54:53 2022 +0000
First released in: 15.0, 13.8, 14.4
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
doc/src/sgml/intarray.sgml | 5 +++++
1 file changed, 5 insertions(+)
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>
[parent: 54299b9ce7cc]