Paul Matthews <p...@netspace.net.au> writes: >> How close is "close"? There's some pretty arbitrary fuzzy-comparisons >> logic in the geometric datatypes ... see FPeq() and friends. That might >> be doing it to you.
> I'll try to figure out how "relatively" close tonight, this stuff is > sub-metre resolution GPS data. The attached picture shows the two > polygons, the shared border, a road in this case, and the houses that > think they are on both sides of the road. Houses and other features are > located with latitude+longitude.<br> Hmm ... just out of curiosity, why aren't you using PostGIS for this? Our built-in geometric types are mostly an academic proof-of-concept, they aren't industrial strength IMHO. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs