Re: Unreliable results returned with PostgreSQL Spatial query? - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: Unreliable results returned with PostgreSQL Spatial query?
Date
Msg-id CAB7nPqRXXB-3vjxb+E4XyCpLO1m5Aus=vTQV4e5ynzJ_ZZJckw@mail.gmail.com
Whole thread Raw
In response to Unreliable results returned with PostgreSQL Spatial query?  ("Burgess, Freddie" <FBurgess@Radiantblue.com>)
List pgsql-bugs
On Thu, Oct 2, 2014 at 12:50 PM, Burgess, Freddie <FBurgess@radiantblue.com>
wrote:
>
> 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));
>
st_intersects is distributed with postgis and not directly with Postgres,
hence this issue would be better discussed from here:
http://postgis.net/support
Regards,
--
Michael

pgsql-bugs by date:

Previous
From: "Burgess, Freddie"
Date:
Subject: Unreliable results returned with PostgreSQL Spatial query?
Next
From: bashtanov@imap.cc
Date:
Subject: BUG #11552: Trigger functions (but not funcs in trigger or rule conditions) are called regardless their privs