Tests whether an ST_Geometry value is spatially equal to another ST_Geometry value. Two geometry values can be considered equal if they have the same x and y coordinates and are in the same reference system.

The test may be limited by the resolution of the spatial reference system or the accuracy of the data.

The ST_Equals function defines the semantics used for comparison predicates (= and <>), IN list predicates, DISTINCT, and GROUP BY.

 Syntax

ST_Equals( geo1,geo2 )

 Parameters

 Returns

 Standards and compatibility

 Example

Select ST_Equals(ST_Point(1,1,4326),ST_Point(1,1,4326))