Insert a temporal cell into another one, or update one with another
insert(tcell,tcell,connect boolean=true) → tcell update(tcell,tcell,connect boolean=true) → tcell
SELECT insert(th3index '[871fa4418ffffff@2001-01-01,
871fa4418ffffff@2001-01-02]', th3index '[871fa44a8ffffff@2001-01-03,
871fa44a8ffffff@2001-01-04]');
-- [871fa4418ffffff@2001-01-01, 871fa44a8ffffff@2001-01-03, 871fa44a8ffffff@2001-01-04]
SELECT insert(tquadbin '[48a6227affffffff@2001-01-01,
48a6227affffffff@2001-01-02]', tquadbin '[485623ffffffffff@2001-01-03,
485623ffffffffff@2001-01-04]');
/* [48a6227affffffff@2001-01-01, 485623ffffffffff@2001-01-03,
485623ffffffffff@2001-01-04] */
SELECT insert(ts2cell '47c3c@2001-01-01', ts2cell '47c4@2001-01-02');
-- {47c3c@2001-01-01, 47c4@2001-01-02}
Delete a time value from a temporal cell
deleteTime(tcell,time,connect boolean=true) → tcell
SELECT deleteTime(th3index '[871fa4418ffffff@2001-01-01, 871fa4418ffffff@2001-01-04]', tstzspan '[2001-01-02, 2001-01-03]'); -- [871fa4418ffffff@2001-01-01, 871fa4418ffffff@2001-01-04] SELECT deleteTime(tquadbin '[48a6227affffffff@2001-01-01, 48a6227affffffff@2001-01-04]', tstzspan '[2001-01-02, 2001-01-03]'); -- [48a6227affffffff@2001-01-01, 48a6227affffffff@2001-01-04] SELECT deleteTime(ts2cell '47c3c@2001-01-01', tstzspan '[2001-01-02, 2001-01-03]'); -- 47c3c@2001-01-01