Skip to main content
This function tests the relationship between two Dimensionally Extended 9-Intersection Model (DE-9IM) matrices representing geometry intersections. It evaluates whether the DE-9IM matrix specified in matrix1 satisfies the intersection pattern defined by matrix2. The matrix2 parameter can be an exact DE-9IM value or a pattern containing wildcard characters.
It is important to note that this function is not optimized for use in spatial join operations. Certain DE-9IM relationships can hold true for geometries that do not intersect or are disjoint. As a result, it is recommended to utilize other dedicated spatial functions specifically optimized for spatial join processing.

​
Signatures

ST_RelateMatch(matrix1: String, matrix2: String)

​
Parameters

​
matrix1
String
required
The matrix1 value.
​
matrix2
String
required
The matrix2 value.

​
Return type

Returns true or false.

​
Example

SELECT ST_RelateMatch('101202FFF', 'TTTTTTFFF')

true