Restrict a temporal cell to (the complement of) a cell or a set of cells

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', s2cell '47c3c');
-- 47c3c@2001-01-01

Restrict a temporal cell to (the complement of) a time value

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', tstzspan '[2001-01-01, 2001-01-02]');
-- 47c3c@2001-01-01