Re: Postgres returning in-correct results with ST_DWithin()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jyoti Leeka <leekajyoti(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgres returning in-correct results with ST_DWithin()
Date: 2017-01-02 16:31:34
Message-ID: 17880.1483374694@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jyoti Leeka <leekajyoti(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message CN 2017-01-03 07:25:26 Re: BUG #14483: Prepared statement does not re-plan while it should
Previous Message Tom Lane 2017-01-02 16:04:27 Re: BUG #14483: Prepared statement does not re-plan while it should