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.