Constructor for temporal JSONB values having a constant value
tjsonb(jsonb,timestamptz) → tjsonbInst tjsonb(jsonb,tstzset) → tjsonbDiscSeq tjsonb(jsonb,tstzspan) → tjsonbContSeq tjsonb(jsonb,tstzspanset) → tjsonbSeqSet
SELECT tjsonb('{"vehicleId": 1, "location": "Point(1 1)"}', timestamptz '2001-01-01');
-- "{\"location\": \"Point(1 1)\", \"vehicleId\": 1}"@2001-01-01
SELECT tjsonb('{"vehicleId": 1, "location": "Point(1 1)"}',
tstzset '{2001-01-01, 2001-01-03, 2001-01-05}');
/* {"{\"location\": \"Point(1 1)\", \"vehicleId\": 1}"@2001-01-01, "{\"location\":
\"Point(1 1)\", \"vehicleId\": 1}"@2001-01-03, "{\"location\": \"Point(1 1)\",
\"vehicleId\": 1}"@2001-01-05} */
SELECT tjsonb('{"vehicleId": 1, "location": "Point(1 1)"}',
tstzspan '[2001-01-01, 2001-01-02]');
/* ["{\"location\": \"Point(1 1)\", \"vehicleId\": 1}"@2001-01-01, "{\"location\":
\"Point(1 1)\", \"vehicleId\": 1}"@2001-01-02] */
SELECT tjsonb('{"vehicleId": 1, "location": "Point(1 1)"}',
tstzspanset '{[2001-01-01, 2001-01-02],[2001-01-03, 2001-01-04]}');
/* {["{\"location\": \"Point(1 1)\", \"vehicleId\": 1}"@2001-01-01, "{\"location\":
\"Point(1 1)\", \"vehicleId\": 1}"@2001-01-02], ["{\"location\": \"Point(1 1)\",
\"vehicleId\": 1}"@2001-01-03, "{\"location\": \"Point(1 1)\", \"vehicleId\":
1}"@2001-01-04]} */
Constructor for temporal JSONB values of sequence subtype
tjsonbSeq(tjsonbInst[],lowerInc boolean=true,upperInc boolean=true) → tjsonbSeq
SELECT tjsonbSeq(ARRAY[tjsonb '"{\"vehicleId\": 1,
\"location\": \"Point(1 1)\"}"@2001-01-01',
'"{\"vehicleId\": 1, \"location\": \"Point(2 2)\"}"@2001-01-02',
'"{\"vehicleId\": 1, \"location\": \"Point(1 1)\"}"@2001-01-03']);
/* ["{\"location\": \"Point(1 1)\", \"vehicleId\": 1}"@2001-01-01, "{\"location\":
\"Point(2 2)\", \"vehicleId\": 1}"@2001-01-02, "{\"location\": \"Point(1 1)\",
\"vehicleId\": 1}"@2001-01-03] */
Constructor for temporal JSONB values of sequence set subtype
tjsonbSeqSet(tjsonb[]) → tjsonbSeqSet tjsonbSeqSetGaps(tjsonbInst[],maxt interval=NULL,maxdist float=NULL) → tjsonbSeqSet
SELECT tjsonbSeqSet(ARRAY[tjsonb '[{"vehicleId": 1, "location": "Point(1 1)"}@2001-01-01,
{"vehicleId": 1, "location": "Point(2 2)"}@2001-01-02]',
'[{"vehicleId": 1, "location": "Point(2 2)"}@2001-01-03,
{"vehicleId": 1, "location": "Point(3 3)"}@2001-01-04]']);
/* {["{\"location\": \"Point(1 1)\", \"vehicleId\": 1}"@2001-01-01, "{\"location\":
\"Point(2 2)\", \"vehicleId\": 1}"@2001-01-02], ["{\"location\": \"Point(2 2)\",
\"vehicleId\": 1}"@2001-01-03, "{\"location\": \"Point(3 3)\", \"vehicleId\":
1}"@2001-01-04]} */
SELECT tjsonbSeqSetGaps(ARRAY[tjsonb '"{\"vehicleId\": 1,
\"location\": \"Point(1 1)\"}"@2001-01-01',
'"{\"vehicleId\": 1, \"location\": \"Point(2 2)\"}"@2001-01-03',
'"{\"vehicleId\": 1, \"location\": \"Point(3 3)\"}"@2001-01-05'], interval '1 day');
/* {["{\"location\": \"Point(1 1)\", \"vehicleId\": 1}"@2001-01-01], ["{\"location\":
\"Point(2 2)\", \"vehicleId\": 1}"@2001-01-03], ["{\"location\": \"Point(3 3)\",
\"vehicleId\": 1}"@2001-01-05]} */