On Thu, May 26, 2011 at 06:17:47PM +0100, Brian Quinion wrote: > Adrian, > > I had this occur once with a schema that I had updated between > versions of postgis. I never did entirely get to the bottom of it - I > ended up adding ::text in a similar way to what Sandro suggested. > i.e.: > > existing.geometry::text != NEW.geometry::text > > It was a crude hack (and probably hurt performance) and didn't seem to > be needed the result of the time so I never committed it.
I'm sure binary tree operators used to do bounding box checks. Your ::text cast instead would do a bitwise comparison. There are few ways to compare geometries, and with recent versions also Hausdorf distance for similarities. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
