| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | "Burgess, Freddie" <FBurgess(at)radiantblue(dot)com> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Unreliable results returned with PostgreSQL Spatial query? |
| Date: | 2014-10-02 04:02:52 |
| Message-ID: | CAB7nPqRXXB-3vjxb+E4XyCpLO1m5Aus=vTQV4e5ynzJ_ZZJckw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Oct 2, 2014 at 12:50 PM, Burgess, Freddie <FBurgess(at)radiantblue(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bashtanov | 2014-10-02 08:42:08 | BUG #11552: Trigger functions (but not funcs in trigger or rule conditions) are called regardless their privs |
| Previous Message | Burgess, Freddie | 2014-10-02 03:50:26 | Unreliable results returned with PostgreSQL Spatial query? |