ST_OrderingEquals — 如果两个几何图形表示相同的几何图形并且具有相同方向顺序的点,则返回True。
boolean
ST_OrderingEquals
(
geometry
A
, geometry
B
)
;
ST_OrderingEquals比较两个几何图形,如果两个几何图形相等且坐标顺序相同,则返回t(True);否则返回f(False)。
![]() |
|
此函数按照ArcSDE SQL规范而不是SQL-MM来实现。Http://edndoc.esri.com/arcsde/9.1/sql_api/sqlapi3.htm#ST_OrderingEquals |
This method implements the SQL/MM specification. SQL-MM 3:5.1.43
SELECT ST_OrderingEquals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),
ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));
st_orderingequals
-----------
f
(1 row)
SELECT ST_OrderingEquals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),
ST_GeomFromText('LINESTRING(0 0, 0 0, 10 10)'));
st_orderingequals
-----------
t
(1 row)
SELECT ST_OrderingEquals(ST_Reverse(ST_GeomFromText('LINESTRING(0 0, 10 10)')),
ST_GeomFromText('LINESTRING(0 0, 0 0, 10 10)'));
st_orderingequals
-----------
f
(1 row)