timeseriesdb icon indicating copy to clipboard operation
timeseriesdb copied to clipboard

Coverage stops 1 timestamp too early

Open HomoCodens opened this issue 3 years ago • 0 comments

Coverage is generated via the following bit: SET coverage = concat('[', ts_data->'time'->0, ',', ts_data->'time'->-1, ')')::daterange;

However this means the last timestamp of a series is always excluded (leading to empty ranges in the extreme case of length-one series).

It should be SET coverage = concat('[', ts_data->'time'->0, ',', ts_data->'time'->-1, ']')::daterange;

HomoCodens avatar Apr 28 '21 09:04 HomoCodens