Two identical points
ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)')
Equals (T*F**FFF*)
|
MariaDB
|
MariaDB [test]> select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)'),'T*F**FFF*') AS equals;
|
+--------+
|
| equals |
|
+--------+
|
| 0 |
|
+--------+
|
1 row in set (0.00 sec)
|
|
PostGIS
|
pgis=# select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)'),'T*F**FFF*') AS equals;
|
equals
|
--------
|
t
|
(1 row)
|
Same for Contains (T*****FF*), Covers (T*****FF*), Within (T*F**F***), Covered by (T*F**F***).
Two different points
ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(1 1)')
Disjoint
|
MariaDB
|
MariaDB [test]> select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(1 1)'),'FF*FF****') as disjoint;
|
+----------+
|
| disjoint |
|
+----------+
|
| 0 |
|
+----------+
|
1 row in set (0.00 sec)
|
|
PostGIS
|
pgis=# select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(1 1)'),'FF*FF****') as disjoint;
|
disjoint
|
----------
|
t
|
(1 row)
|
|