Re: [BUGS] Postgres returning in-correct results with ST_DWithin() - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] Postgres returning in-correct results with ST_DWithin()
Date
Msg-id 17880.1483374694@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] Postgres returning in-correct results with ST_DWithin()  (Jyoti Leeka <leekajyoti@gmail.com>)
List pgsql-bugs
Jyoti Leeka <leekajyoti@gmail.com> writes:
> However, to my surprise I found that although A and B are separated from
> each other by a distance greater than 50 km (50.995 km to be precise. Found
> using Chris Veness's geodesy formulae​ (
>
http://stackoverflow.com/questions/27461634/calculate-distance-between-a-point-and-a-line-segment-in-latitude-and-longitude)),
> yet they are returned by postgres as results.

I think you need to ask about that on the Postgis mailing lists, not here.

            regards, tom lane


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14483: Prepared statement does not re-plan while it should
Next
From: CN
Date:
Subject: Re: [BUGS] BUG #14483: Prepared statement does not re-plan while itshould