제목

ST_OrderingEquals — Tests if two geometries represent the same geometry and have points in the same directional order

요약

boolean ST_OrderingEquals(geometry A, geometry B);

설명

ST_OrderingEquals compares two geometries and returns t (TRUE) if the geometries are equal and the coordinates are in the same order; otherwise it returns f (FALSE).

[참고]

This function is implemented as per the ArcSDE SQL specification rather than 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

예시

Code
SELECT ST_OrderingEquals('LINESTRING(0 0,10 10)',
'LINESTRING(0 0,5 5,10 10)');
래스터 출력
f
Figure
Geometry figure for visual-st-orderingequals-01
Code
SELECT ST_OrderingEquals('LINESTRING(0 0,10 10)',
'LINESTRING(0 0,10 10)');
래스터 출력
t
Figure
Geometry figure for visual-st-orderingequals-02
Code
SELECT ST_OrderingEquals('POLYGON((0 0,0 1,1 1,1 0,0 0))',
'POLYGON((0 0,1 0,1 1,0 1,0 0))');
래스터 출력
f
Figure
Geometry figure for visual-st-orderingequals-03