[postgis-users] equals function not working correctly

[strk at refractions.net]

On Fri, Feb 18, 2005 at 02:15:05AM -0500, dblasby at openplans.org wrote:
> >   id   |                           the_geom
> > -------+--------------------------------------------------------------
> >  21802 | SRID=4326;MULTIPOLYGON(((-3 -70,-3 85,-3 85,-3 -70,-3 -70)))
> > (1 row)
> 
> This multipolygon isnt valid - "equals" only works on valid geometries. 
> You can probably use the JTS function equalsExact() or the normal
> postgresql "=" function.
> 
> dave

You should use ~= for vertex-by-vertex equality check.
The = operator olny considers BBOX equality.

--strk;