diff options
| -rw-r--r-- | doc/src/sgml/array.sgml | 14 | ||||
| -rw-r--r-- | doc/src/sgml/func.sgml | 3 |
2 files changed, 16 insertions, 1 deletions
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>&&</> 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> |