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: | Raw Message | Whole Thread | 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 |