Home > mailing lists

Discrepancy in query output - Mailing list pgsql-sql

From	Lahari Sengupta
Subject	Discrepancy in query output
Date	February 22, 2018 19:20:56
Msg-id	CAKEx41qmhUgdHgovkVibPVOiC3oT+xE7B7H=uNPHbWYiCZV_Ew@mail.gmail.com Whole thread Raw
Responses	Re: Discrepancy in query output (Lahari Sengupta <jhinik8@gmail.com>)
List	pgsql-sql

Tree view

My following query sometimes gives 72 rows and sometimes gives 71 rows as output. How could it misses one?

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 AND sv.timing >= timestamp '2018-02-02 00:00:00'

and sv.timing <= timestamp '2018-02-02 23:59:59'

pgsql-sql by date:

From: ROS Didier
Date: 19 February 2018, 22:22:36
Subject: RE: barman 1.3.3 - barman list-backup ne montre pas tous les backup disponibles

From: Lahari Sengupta
Date: 22 February 2018, 19:56:25
Subject: Re: Discrepancy in query output

Discrepancy in query output - Mailing list pgsql-sql

Previous

Next