->, ->>, jsonbsetObjectField, jsonbsetObjectFieldText: Extract a JSON object field specified by a key
->, ->>, jsonbsetExtractPath, jsonbsetExtractPathText: Extract a JSON object field specified by a path
jsonbsetArrayElement, jsonbsetArrayElementText: Extract an element from a JSON array
intset, floatset, textset: Extract a alphanumeric value from a JSONB set given by a key
||: JSONB set concatenation
-: JSONB set deletion
?: JSONB set exists
jsonbsetSet, jsonbsetSetLax: JSONB set assignment
jsonbsetInsert: Return the jsonbset value with jsonb inserted
jsonbsetStripNulls: Return a JSONB set without nulls
@?, jsonbsetPathExists, jsonbsetPathExistsTz: Does the JSON path return any item for the specified JSONB set?
@@, jsonbsetPathMatch, jsonbsetPathMatchTz: Return the result of a JSON path predicate check for a JSONB set
jsonbsetPathQueryArray, jsonbsetPathQueryArrayTz: Return all items returned by a JSON path from a JSONB set, as a JSON array
jsonbsetPathQueryFirst, jsonbsetPathQueryFirstTz: Return the fist item returned by a JSON path from a JSONB set
asText: Return the Well-Known Text (WKT) representation
asBinary, asHexWKB: Return the Well-Known Binary (WKB) or the Hexadecimal Well-Known Binary (HexWKB) representation
asMFJSON: Return the Moving Features JSON (MF-JSON) representation
tjsonbFromText: Input from the Well-Known Text (WKT) representation
tjsonbFromBinary, tjsonbFromHexWKB: Input from the Well-Known Binary (WKB) or from the Hexadecimal Well-Known Binary (HexWKB) representation
tjsonbFromMFJSON: Input from the Moving Features JSON (MF-JSON) representation
tjsonb: Constructor for temporal JSONB values having a constant value
tjsonbSeq: Constructor for temporal JSONB values of sequence subtype
tjsonbSeqSet, tjsonbSeqSetGaps: Constructor for temporal JSONB values of sequence set subtype
getValues: Return the values
valueAtTimestamp: Return the value at a timestamp
tjsonbInst, tjsonbSeq, tjsonbSeqSet: Transform a temporal JSONB to another subtype
setInterp: Transform a temporal JSONB value to another interpolation
->, ->>, tjsonObjectField, tjsonbObjectField, tjsonbObjectFieldText: Extract a temporal JSON object field specified by a key
->, ->>, tjsonExtractPath, tjsonbExtractPath, tjsonbExtractPathText: Extract a temporal JSON object field specified by a path
tjsonArrayElement, tjsonbArrayElement, tjsonbArrayElementText: Extract an element from a temporal JSON array
tbool, tint, tfloat, ttext: Extract a temporal alphanumeric value from a temporal JSONB value given by a key
||: Temporal JSONB concatenation
-: Temporal JSONB deletion
?: Temporal JSONB exists
@>, <@: Temporal JSONB contains/contained
tjsonbSet, tjsonbSetLax: Temporal JSONB set
tjsonbInsert: Temporal JSONB insert
tjsonStripNulls, tjsonbStripNulls: Return a temporal JSON value without nulls
@?, tjsonbPathExists, tjsonbPathExistsTz: Does the JSON path return any item for the specified temporal JSONB value?
@@, tjsonbPathMatch, tjsonbPathMatchTz: Return the result of a JSON path predicate check for a temporal JSONB value
tjsonbPathQueryArray, tjsonbPathQueryArrayTz: Return all items returned by a JSON path from a temporal JSONB value, as a JSON array
tjsonbPathQueryFirst, tjsonbPathQueryFirstTz: Return the fist item returned by a JSON path from a temporal JSONB value
atValue, minusValue, atValues, minusValues: Restrict to (the complement of) a value or a set of values
&&, <@, @>, ~=, -|-: Topological operators
::: Position operators
=, <>, <, >, <=, >=: Traditional comparisons
?=, %=: Ever and always comparisons
::: Temporal comparisons