ST_intersectioni¶
Find the set intersection of two vectors and returns an index vector with the positions in a. (All the elements that are in a and b)
-
c = ST_intersectioni(a, b)
Return Value
c*is an index vector with the intersection of *a and b. If an intersection doesn’t exist the functions returns 0.
Parameters
-
a
a is a string or real matrix.
-
b
b is a string or real matrix.
Example
* ST_intersectioni([2.1,3.3,5,4.1,7], [2.1,4.1,9])
1.000 4.000
*
* ST_intersectioni(["one", "two", "three"], ["two", "four", "five"])
2.000
See also
Overview Strings, ST_complement, ST_set, ST_seti, ST_union, ST_intersection, find
id-1607093