postgres.git / summary / log / commit / refs
commit 185c6bc4aef1201b7d0f2c4e9c8893c4a663dfd4
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Thu Jun 25 17:28:30 2020 +0000
First released in: 14.0, 13.0
Doc: correct nitpicky mistakes in array_position/array_positions examples.
Daniel Gustafsson and Erik Rijkers, per report from nick@cleaton
Discussion: https://postgr.es/m/159275646273.679.16940709892308114570@wrigleys.postgresql.org
doc/src/sgml/array.sgml | 8 +++++---
1 file changed, 5 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/array.sgml b/doc/src/sgml/array.sgml
index a473fa8ee8b..56185b9b038 100644
--- a/doc/src/sgml/array.sgml
+++ b/doc/src/sgml/array.sgml
@@ -669,14 +669,16 @@ SELECT * FROM sal_emp WHERE pay_by_quarter && ARRAY[10000];
<programlisting>
SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon');
- array_positions
------------------
- 2
+ array_position
+----------------
+ 2
+(1 row)
SELECT array_positions(ARRAY[1, 4, 3, 1, 3, 4, 2, 1], 1);
array_positions
-----------------
{1,4,8}
+(1 row)
</programlisting>
</para>
[parent: 126c8fcec790]