Shift, scale, or shift and scale the time span of a temporal cell

shiftTime(tcell,interval) → tcell
scaleTime(tcell,interval) → tcell
shiftScaleTime(tcell,interval,interval) → tcell

SELECT shiftTime(th3index '871fa4418ffffff@2001-01-01', interval '1 day');
-- 871fa4418ffffff@2001-01-02
SELECT scaleTime(th3index '[871fa4418ffffff@2001-01-01,
  871fa44a8ffffff@2001-01-03]', interval '4 days');
-- [871fa4418ffffff@2001-01-01, 871fa44a8ffffff@2001-01-05]
SELECT shiftTime(tquadbin '48a6227affffffff@2001-01-01', interval '1 day');
-- 48a6227affffffff@2001-01-02
SELECT scaleTime(tquadbin '[48a6227affffffff@2001-01-01,
  485623ffffffffff@2001-01-03]', interval '4 days');
-- [48a6227affffffff@2001-01-01, 485623ffffffffff@2001-01-05]
SELECT shiftTime(ts2cell '47c3c@2001-01-01', interval '1 day');
-- 47c3c@2001-01-02
SELECT scaleTime(ts2cell '[47c3c@2001-01-01, 47c4@2001-01-03]', interval '4 days');
-- [47c3c@2001-01-01, 47c4@2001-01-05]

Append a temporal instant or a temporal sequence

appendInstant(tcell,tcellInst) → tcell
appendSequence(tcell,tcellSeq) → tcell

SELECT asText(appendInstant(th3index '831c02fffffffff@2001-01-01',
  th3index '831c00fffffffff@2001-01-02'));
-- [831c02fffffffff@2001-01-01, 831c00fffffffff@2001-01-02]
SELECT asText(appendSequence(tquadbin '[48a6227affffffff@2001-01-01]',
  tquadbin '[485623ffffffffff@2001-01-02]'));
-- {[48a6227affffffff@2001-01-01], [485623ffffffffff@2001-01-02]}

Merge the temporal cells

merge(tcell,tcell) → tcell
merge(tcell[]) → tcell

SELECT asText(merge(ts2cell '[47c3c@2001-01-01, 47c3c@2001-01-03]',
  ts2cell '[47c3c@2001-01-03, 47c4@2001-01-05]'));
-- [47c3c@2001-01-01, 47c4@2001-01-05]
SELECT asText(merge(ARRAY[th3index '831c02fffffffff@2001-01-01',
  th3index '831c00fffffffff@2001-01-03']));
-- {831c02fffffffff@2001-01-01, 831c00fffffffff@2001-01-03}

Set the interpolation of a temporal cell

setInterp(tcell,interp text) → tcell

SELECT setInterp(th3index '{871fa4418ffffff@2001-01-01,
  871fa44a8ffffff@2001-01-02}', 'step');
-- {[871fa4418ffffff@2001-01-01], [871fa44a8ffffff@2001-01-02]}
SELECT setInterp(tquadbin '{48a6227affffffff@2001-01-01,
  485623ffffffffff@2001-01-02}', 'step');
-- {[48a6227affffffff@2001-01-01], [485623ffffffffff@2001-01-02]}
SELECT setInterp(ts2cell '{47c3c@2001-01-01}', 'step');
-- [47c3c@2001-01-01]