ST_intersection¶
Find the set intersection of two vectors. (All the elements that are in a and b)
-
c = ST_intersection(a, b)
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.
Parameters
-
a
a is a string or real matrix.
-
b
b is a string or real matrix.
Example
* ST_intersection([2,3,5,4,7], [2,4,9])
* 2.000 4.000
*
* ST_intersection(["one", "two", "three"], ["two", "four", "five"])'
two
See also
id-1675452