Restringir una celda temporal a (el complemento de) una celda o un conjunto de celdas

atValue(tcell,cell) → tcell
minusValue(tcell,cell) → tcell
atValues(tcell,cellset) → tcell
minusValues(tcell,cellset) → tcell

SELECT atValue(th3index '{871fa4418ffffff@2001-01-01,
  871fa44a8ffffff@2001-01-02}', h3index '871fa4418ffffff');
-- {871fa4418ffffff@2001-01-01}
SELECT atValue(tquadbin '{48a6227affffffff@2001-01-01, 485623ffffffffff@2001-01-02}',
  quadbin '48a6227affffffff');
-- {48a6227affffffff@2001-01-01}
SELECT atValue(ts2cell '{47c3c@2001-01-01, 47c4@2001-01-02}',
  s2cell '47c3c');
-- {47c3c@2001-01-01}

Restringir una celda temporal a (el complemento de) un valor de tiempo

atTime(tcell,time) → tcell
minusTime(tcell,time) → tcell

SELECT atTime(th3index '[871fa4418ffffff@2001-01-01,
  871fa4418ffffff@2001-01-04]', tstzspan '[2001-01-02, 2001-01-03]');
-- [871fa4418ffffff@2001-01-02, 871fa4418ffffff@2001-01-03]
SELECT atTime(tquadbin '[48a6227affffffff@2001-01-01, 48a6227affffffff@2001-01-04]',
  tstzspan '[2001-01-02, 2001-01-03]');
-- [48a6227affffffff@2001-01-02, 48a6227affffffff@2001-01-03]
SELECT atTime(ts2cell '[47c3c@2001-01-01, 47c3c@2001-01-04]',
  tstzspan '[2001-01-02, 2001-01-03]');
-- [47c3c@2001-01-02, 47c3c@2001-01-03]