ST_RelateMatch function to check if an intersection matrix complies with an intersection pattern - PolarDB

Tests whether an intersection matrix satisfies an intersection pattern.

Syntax

boolean ST_RelateMatch(text intersectionMatrix, text intersectionMatrixPattern);

Parameter	Description
`intersectionMatrix`	The intersection matrix that you want to specify.
`intersectionMatrixPattern`	The intersecting pattern that you want to specify.

The following example shows how ST_RelateMatch evaluates a matrix against a pattern, returning true when the matrix satisfies the pattern.

Match: returns true

SELECT ST_RelateMatch('FF1F00102', 'FF*******');
 st_relatematch
----------------
 t
(1 row)

The matrix 'FF1F00102' starts with FF, which matches the pattern 'FF*******' (the remaining seven positions accept any value).