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

From Paul Matthews
Subject BUG #4967: polygon @> point incorrect for points close to shared borders
Date
Msg-id 200908060756.n767uBBO047570@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4967: polygon @> point incorrect for points close to shared borders  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4967
Logged by:          Paul Matthews
Email address:      plm@netspace.net.au
PostgreSQL version: 8.3.7
Operating system:   Linux Open Suse 11.0 + 11.1
Description:        polygon @> point incorrect for points close to shared
borders
Details:

Have two polygons, both with many vertex, sharing a common edge. Several
thousand points where then tested to see which of the polygons the points
fell into using the "polygon @> point" operator.

A number of points close to the common border claimed they fell into both of
the polygons.

A quick perl+DBI+GD application was developed to plot both the polygons, the
polygon boundaries, as well as the points that thought they where in both.

This showed points close, but still several pixels away from the shared
border, thinking they where in both.

Guidance on this matter would be appreciated.

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #4966: wrong password.....
Next
From: Tom Lane
Date:
Subject: Re: BUG #4966: wrong password.....