Las funciones de agregación para celdas quadbin temporales se ilustran a continuación.
Conteo temporal
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)}
Conteo en ventana
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)}