All Products
Search
Document Center

PolarDB:ST_RelateMatch

Last Updated:Mar 28, 2026

Tests whether a Dimensionally Extended 9-Intersection Model (DE-9IM) intersection matrix satisfies a given intersection pattern.

Syntax

boolean ST_RelateMatch(text intersectionMatrix, text intersectionMatrixPattern);

Parameters

ParameterDescription
intersectionMatrixThe intersection matrix that you want to specify.
intersectionMatrixPatternThe intersecting pattern that you want to specify.

Examples

Check an intersection matrix by using the default parameter settings.

SELECT ST_RelateMatch('FF1F00102', 'FF*******');

Output:

 st_relatematch
----------------
 t
(1 row)