Construct a temporal cell holding one cell over a time value
tcell(cell,timestamptz) → tcellInst tcell(cell,tstzset) → tcellDiscSeq tcell(cell,tstzspan) → tcellSeq tcell(cell,tstzspanset) → tcellSeqSet
SELECT th3index(h3index '871fa4418ffffff', timestamptz '2001-01-01'); -- 871fa4418ffffff@2001-01-01 SELECT th3index(h3index '871fa4418ffffff', tstzspan '[2001-01-01, 2001-01-03]'); -- [871fa4418ffffff@2001-01-01, 871fa4418ffffff@2001-01-03] SELECT tquadbin(quadbin '48a6227affffffff', timestamptz '2001-01-01'); -- 48a6227affffffff@2001-01-01 SELECT tquadbin(quadbin '48a6227affffffff', tstzspan '[2001-01-01, 2001-01-03]'); -- [48a6227affffffff@2001-01-01, 48a6227affffffff@2001-01-03] SELECT ts2cell(s2cell '47c3c', timestamptz '2001-01-01'); -- 47c3c@2001-01-01 SELECT ts2cell(s2cell '47c3c', tstzspan '[2001-01-01, 2001-01-03]'); -- [47c3c@2001-01-01, 47c3c@2001-01-03]
Construct a temporal cell of a given subtype from its components
tcellInst(tcell) → tcellInst tcellSeq(tcell[],interp text='step') → tcellSeq tcellSeqSet(tcell[]) → tcellSeqSet
SELECT th3indexSeq(ARRAY[th3index '871fa4418ffffff@2001-01-01', th3index '871fa44a8ffffff@2001-01-02'], 'step'); -- [871fa4418ffffff@2001-01-01, 871fa44a8ffffff@2001-01-02] SELECT tquadbinSeq(ARRAY[tquadbin '48a6227affffffff@2001-01-01', tquadbin '485623ffffffffff@2001-01-02'], 'step'); -- [48a6227affffffff@2001-01-01, 485623ffffffffff@2001-01-02] SELECT ts2cellSeq(ARRAY[ts2cell '47c3c@2001-01-01', ts2cell '47c4@2001-01-02'], 'step'); -- [47c3c@2001-01-01, 47c4@2001-01-02]