ST_complement

Compute the complement of a in b (the elements of b that are not in a).

c = ST_complement(a, b)

c = ST_complement(a, b, rsNull)

Return Value

c is a vector with the elements of b that are not in a or 0 (for real) or “” (for string).

Parameters

a

a is a string or real matrix.

b

b is a string or real matrix.

rsNull

rsNull is the return value if b contains only elements that are in a. The parameter is only used with real matrices.

Example

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

See also

Overview Strings, ST_intersection, ST_set, ST_union

_id-975428