[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] what does it really mean for one geometry to be equal to another
From:       Sandro Santilli <strk () kbt ! io>
Date:       2016-09-16 7:11:50
Message-ID: 20160916071150.GA9706 () localhost
[Download RAW message or body]

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
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]