| From: | "Konrad Garus" <konrad(dot)garus(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5889: "Intersects" for polygons broken |
| Date: | 2011-02-16 10:58:28 |
| Message-ID: | 201102161058.p1GAwS5V009535@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5889
Logged by: Konrad Garus
Email address: konrad(dot)garus(at)gmail(dot)com
PostgreSQL version: 8.4
Operating system: Linux
Description: "Intersects" for polygons broken
Details:
&& 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)
It reportedly is different in 9.0
(http://stackoverflow.com/q/5015233/277683)
Docs could do better job explaining what types each of the geometry operator
supports, and whether intersecting polygons support nonconvex polygons as
well, or only uses bounding box as criteria.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2011-02-16 13:45:50 | Re: possible bug: orphaned files left after immediate shutdown during DDL |
| Previous Message | Maxim Boguk | 2011-02-16 09:24:16 | Re: BUG #5885: Strange rows estimation for left join |