Re: Discrepancy in query output

On Thu, Feb 22, 2018 at 6:56 AM, Lahari Sengupta <[email protected]> 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.