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

Paul Norman penorman at mac.com
Thu Sep 15 23:37:38 PDT 2016


On 9/15/2016 11:19 PM, Paul Norman wrote:
> I don't know of a great way to do this, but a bad way that might work 
> is EXCLUDE USING GIST (ST_Buffer(geom, 0.1) WITH &&). See 
> https://www.postgresql.org/docs/current/static/rangetypes.html#RANGETYPES-CONSTRAINT 
> and the links from there. I haven't tested this.

After further though, this is doing a bounding box comparison so it's 
not quite 0.1 projected units and you can use ST_Expand instead of 
ST_Buffer.


More information about the postgis-users mailing list