Re: BUG #5889: "Intersects" for polygons broken
От | Tom Lane |
---|---|
Тема | Re: BUG #5889: "Intersects" for polygons broken |
Дата | |
Msg-id | 25122.1297870318@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | BUG #5889: "Intersects" for polygons broken ("Konrad Garus" <konrad.garus@gmail.com>) |
Ответы |
Re: BUG #5889: "Intersects" for polygons broken
|
Список | pgsql-bugs |
"Konrad Garus" <konrad.garus@gmail.com> writes: > && operator seems to be broken for polygons whose bounding boxes intersect: > select polygon'((0,0), (1,2), (0,2))' && polygon'((0.5, 0), (1,0), (1,1))'; > ?column? > ---------- > t > (1 row) This is fixed as of 9.0; see the release notes at http://www.postgresql.org/docs/9.0/static/release-9-0.html which say Correct calculations of "overlaps" and "contains" operations for polygons (Teodor Sigaev) The polygon && (overlaps) operator formerly just checked to see if the two polygons' bounding boxes overlapped. It now does a more correct check. The polygon @> and <@ (contains/contained by) operators formerly checked to see if one polygon's vertexes were all contained in the other; this can wrongly report "true" for some non-convex polygons. Now they check that all line segments of one polygon are contained in the other. regards, tom lane
В списке pgsql-bugs по дате отправления: