.. highlightlang:: us

.. _st_intersection:

ST_intersection
===============

.. index:: ST_intersection

.. us.tag  ST_intersection NOTREADYENGLISH STR New300

Find the set intersection of two vectors.
(All the elements that are in *a* and *b*)

.. function::  c = ST_intersection(a, b)

.. us.return

**Return Value**

*c*is a vector with the intersection of *a* and *b*. If an intersection
doesn't exist the functions returns 0 for real vectors or "" for string vectors.

.. us.params

**Parameters**

.. uparam:: a

   *a* is a string or real matrix.

.. uparam:: b

   *b* is a string or real matrix.

.. us.example

**Example**

::

   * ST_intersection([2,3,5,4,7], [2,4,9])
   *    2.000    4.000
   *
   * ST_intersection(["one", "two", "three"], ["two", "four", "five"])'
   two

.. seealso::
   :ref:`overview-strings`,
   :ref:`ST_complement`,
   :ref:`ST_set`,
   :ref:`ST_union`

:sub:`id-1675452`