postgis/regress/core/relatematch.sql
2018-10-19 23:06:30 +00:00

13 lines
612 B
SQL

SELECT a, b, ST_RelateMatch(a,b) FROM
( SELECT '101202FFF'::text as a, 'TTTTTTFFF'::text as b) as f;
SELECT a, b, ST_RelateMatch(a,b) FROM
( SELECT '101202FFF'::text as a, 'T0T2TTFFF'::text as b) as f;
SELECT a, b, ST_RelateMatch(a,b) FROM
( SELECT '101202FFF'::text as a, '101202FFF'::text as b) as f;
SELECT a, b, ST_RelateMatch(a,b) FROM
( SELECT '101202FFF'::text as a, '101102FFF'::text as b) as f;
SELECT a, b, ST_RelateMatch(a,b) FROM
( SELECT 'FFFFFFFFF'::text as a, '1FFFFFFFF'::text as b) as f;
SELECT a, b, ST_RelateMatch(a,b) FROM
( SELECT 'FFFFFFFFF'::text as a, '*FFFFFFFF'::text as b) as f;