Re: Discrepancy in query output

On Thu, Feb 22, 2018 at 6:56 AM, Lahari Sengupta <jhinik8@gmail.com> wrote:

Specially, if I remove the timing condition and want to select all from servers then it misses one. How is it possible?

 

st_distance(sv.geom, st.geom)<8.5) where

​Apparently st_distance() is non-deterministic in its output of float representations.  Its seems likely (though I'm by no means fluent on floating-point concerns) to be a problem specific to the implementation of that function and thus better asked on a PostGIS list.  You should identify the "extra" row and see if you can include it in a self-contained query that demonstrates occasionally returning false for the condition when normally it returns true.

David J.