Unreliable results returned with PostgreSQL Spatial query?

From: "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Unreliable results returned with PostgreSQL Spatial query?
Date: 2014-10-02 03:50:26
Message-ID: 3BBE635F64E28D4C899377A61DAA9FE03F0912CB@NBSVR-MAIL01.radiantblue.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PostgreSQL version: 9.3.4
PostGIS version 2.1.1
Operating system: Linux 6.4
Description:

Does the ST_Intersects function have problems returning the correct results with non-box type geometries, like a circle polygon or other style polygons.

i.e.

select count(*) from doti_sensors_report where ST_INTERSECTS(sensor_location, ST_Buffer(ST_MakePoint(21.304116745663165, 38.68607570952619)::geography, 4000));

thanks

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2014-10-02 04:02:52 Re: Unreliable results returned with PostgreSQL Spatial query?
Previous Message Alvaro Herrera 2014-10-01 21:32:12 Re: BUG #11264: Auto vacuum wraparound job blocking everything