[postgis-users] Discrepancy in result

Lahari Sengupta jhinik8 at gmail.com
Thu Feb 22 08:39:40 PST 2018

My following query gives output of 72 rows which is correct.

SELECT distinct on (st.gid) sv.timing, st.gid, st.areaFROM servers
svINNER JOIN sites stON (st_distance(sv.geom, st.geom)<8.5) where
        sv.workmode = 1 AND sv.timing >= timestamp '2018-02-02 00:00:00'
        and sv.timing <= timestamp '2018-02-02 23:59:59';

But if I remove the condition on timing and want to find out whole output,
it misses one row which is between this time. Why is it happening? What is
wrong with my query?

SELECT distinct on (st.gid) sv.timing, st.gid, st.area
    FROM servers sv
    INNER JOIN sites st
    ON (st_distance(sv.geom, st.geom)<8.5) where
            sv.workmode = 1;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180222/169af4e8/attachment.html>

More information about the postgis-users mailing list