postgres.git / summary / log / commit / refs

commit    6ef5baf8b1cb609218b2fafb378b3f190a6f90f9
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Fri Jun 22 12:59:41 2012 +0000
First released in: 9.3.0

    Document that && can be used to search arrays.
    
    Also, add some cross-links to the indexing documentation, so it's easier
    to notice that && and other array operators have index support.
    
    Ryan Kelly, edited by me.


 doc/src/sgml/array.sgml | 14 ++++++++++++++
 doc/src/sgml/func.sgml  |  3 ++-
 2 files changed, 16 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/array.sgml b/doc/src/sgml/array.sgml
index 3508ba3e3c8..8b36d4ab85f 100644
--- a/doc/src/sgml/array.sgml
+++ b/doc/src/sgml/array.sgml
@@ -573,6 +573,20 @@ SELECT * FROM
   This function is described in <xref linkend="functions-srf-subscripts">.
  </para>
 
+ <para>
+  You can also search an array using the <literal>&amp;&amp;</> operator,
+  which checks whether the left operand overlaps with the right operand.
+  For instance:
+
+<programlisting>
+SELECT * FROM sal_emp WHERE pay_by_quarter && ARRAY[10000];
+</programlisting>
+
+  This and other array operators are further described in
+  <xref linkend="functions-array">.  It can be accelerated by an appropriate
+  index, as described in <xref linkend="indexes-types">.
+ </para>
+
  <tip>
   <para>
    Arrays are not sets; searching for specific array elements
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index cd374ac350b..595523e3eba 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -10282,7 +10282,8 @@ SELECT NULLIF(value, '(none)') ...
 
   <para>
    See <xref linkend="arrays"> for more details about array operator
-   behavior.
+   behavior.  See <xref linkend="indexes-types"> for more details about
+   which operators support indexed operations.
   </para>
 
   <para>


[parent: 6753ced31040]