Temporal count

tCount(tquadbin) → {tintSeq,tintSeqSet}

WITH Temp(temp) AS (
  SELECT tquadbin '[480fffffffffffff@2001-01-01, 480fffffffffffff@2001-01-03)' UNION
  SELECT tquadbin '[48427fffffffffff@2001-01-02, 48427fffffffffff@2001-01-04)' UNION
  SELECT tquadbin '[48a6227affffffff@2001-01-03, 48a6227affffffff@2001-01-05)' )
SELECT tCount(Temp)
FROM Temp;
-- {[1@2001-01-01, 2@2001-01-02, 1@2001-01-04, 1@2001-01-05)}

Window count

wCount(tquadbin) → {tintSeq,tintSeqSet}

WITH Temp(temp) AS (
  SELECT tquadbin '[480fffffffffffff@2001-01-01, 480fffffffffffff@2001-01-03)' UNION
  SELECT tquadbin '[48427fffffffffff@2001-01-02, 48427fffffffffff@2001-01-04)' UNION
  SELECT tquadbin '[48a6227affffffff@2001-01-03, 48a6227affffffff@2001-01-05)' )
SELECT wCount(Temp, interval '1 day')
FROM Temp;
-- {[1@2001-01-01, 2@2001-01-02, 3@2001-01-03, 2@2001-01-04, 1@2001-01-05, 1@2001-01-06)}