ST_OrderingEquals( ST_Geometry ) method

Syntax

geometry-expression.ST_OrderingEquals( ST_Geometry geo2)

Parameters

• geo2 – The other geometry value that is to be compared to the geometry-expression.

Returns

BIT Returns 1 if the two geometry values are exactly equal, otherwise 0.

Examples

• Example 1 – The following example returns the result 16. The Shape corresponding to ShapeID the result 16 contains the exact same points in the exact same order as the specified polygon.

  SELECT ShapeID FROM SpatialShapes
  WHERE Shape.ST_OrderingEquals( NEW ST_Polygon( 'Polygon ((0 0, 2 0, 1 2, 0 0))' ) ) = 1

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.43