[postgis-users] what does it really mean for one geometry to be equal to another

Sandro Santilli strk at kbt.io
Fri Sep 16 00:11:50 PDT 2016


On Thu, Sep 15, 2016 at 11:19:49PM -0700, Paul Norman wrote:

> If you did want to require
> unique geometries, you could do it with a btree index on the
> geometry, not st_astext of the geometry.

The btree opclass for geometry only checks bounding box equality,
not geometry equality (see lwgeom_eq, aka OPERATOR=).

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   https://strk.kbt.io/services.html


More information about the postgis-users mailing list