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;
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;