Desplazar, escalar, o desplazar y escalar el lapso de tiempo de una celda temporal

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]

Añadir un instante temporal o una secuencia temporal

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(th3index '[831c02fffffffff@2001-01-01]',
  th3index '[831c00fffffffff@2001-01-02]'));
-- {[831c02fffffffff@2001-01-01], [831c00fffffffff@2001-01-02]}
SELECT asText(appendInstant(tquadbin '48a6227affffffff@2001-01-01',
  tquadbin '485623ffffffffff@2001-01-02'));
-- [48a6227affffffff@2001-01-01, 485623ffffffffff@2001-01-02]
SELECT asText(appendSequence(tquadbin '[48a6227affffffff@2001-01-01]',
  tquadbin '[485623ffffffffff@2001-01-02]'));
-- {[48a6227affffffff@2001-01-01], [485623ffffffffff@2001-01-02]}
SELECT asText(appendInstant(ts2cell '47c3c@2001-01-01',
  ts2cell '47c4@2001-01-02'));
-- [47c3c@2001-01-01, 47c4@2001-01-02]
SELECT asText(appendSequence(ts2cell '[47c3c@2001-01-01]',
  ts2cell '[47c4@2001-01-02]'));
-- {[47c3c@2001-01-01], [47c4@2001-01-02]}

Fusionar las celdas temporales

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

SELECT asText(merge(th3index '[831c02fffffffff@2001-01-01, 831c02fffffffff@2001-01-03]',
  th3index '[831c02fffffffff@2001-01-03, 831c00fffffffff@2001-01-05]'));
-- [831c02fffffffff@2001-01-01, 831c00fffffffff@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}
SELECT asText(merge(tquadbin '[48a6227affffffff@2001-01-01, 48a6227affffffff@2001-01-03]',
  tquadbin '[48a6227affffffff@2001-01-03, 485623ffffffffff@2001-01-05]'));
-- [48a6227affffffff@2001-01-01, 485623ffffffffff@2001-01-05]
SELECT asText(merge(ARRAY[tquadbin '48a6227affffffff@2001-01-01',
  tquadbin '485623ffffffffff@2001-01-03']));
-- {48a6227affffffff@2001-01-01, 485623ffffffffff@2001-01-03}
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[ts2cell '47c3c@2001-01-01',
  ts2cell '47c4@2001-01-03']));
-- {47c3c@2001-01-01, 47c4@2001-01-03}

Establecer la interpolación de una celda temporal

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