diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2022-06-03 13:54:53 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2022-06-03 13:54:58 -0400 |
| commit | c1ad8047a2c22f841e4e3df39696febeb7167e6c (patch) | |
| tree | b18b30547c1f13185a3ec55539751cfd0ee85626 | |
| parent | 2223c2a7c4403e71c2553c313e958503084077f3 (diff) | |
| download | postgresql-c1ad8047a2c22f841e4e3df39696febeb7167e6c.tar.gz postgresql-c1ad8047a2c22f841e4e3df39696febeb7167e6c.zip | |
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.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/intarray.sgml b/doc/src/sgml/intarray.sgml index f930c08eeb7..18c6f8c3bae 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> |