5. Geospatial Functions : Equals
 
Share this page                  
Equals
EQUALS(g1 Geometry, g2 Geometry)
Alias: ST_EQUALS
Returns 1 if g1 is the same as g2; returns 0 otherwise.
Result type: integer
Examples:
SELECT EQUALS(POINTFROMTEXT('POINT(7 17)'), POINTFROMTEXT('POINT(1 2)'));
-------------
col1         
-------------
0
-------------
SELECT EQUALS(POINTFROMTEXT('POINT(7 17)'), POINTFROMTEXT('POINT(7 17)'));
-------------
col1         
-------------
1
-------------