Re: BUG #4967: polygon @> point incorrect for points close to shared borders - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4967: polygon @> point incorrect for points close to shared borders
Date
Msg-id 7731.1249600862@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4967: polygon @> point incorrect for points close to shared borders  (Paul Matthews <plm@netspace.net.au>)
List pgsql-bugs
Paul Matthews <plm@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

pgsql-bugs by date:

Previous
From: Paul Matthews
Date:
Subject: Re: BUG #4967: polygon @> point incorrect for points close to shared borders
Next
From: "Rob Wultsh"
Date:
Subject: BUG #4970: Broken link in manual