jsonbObjectField, jsonbObjectFieldText: Extract a JSON object field specified by a key

jsonbExtractPath, jsonbExtractPathText: Extract a JSON value specified by a path

jsonbArrayElement, jsonbArrayElementText: Extract an element from a JSON array

jsonbArrayLength: Return the number of elements of a JSON array

jsonbArrayElements, jsonbArrayElementsText: Return the elements of a JSON array as rows

jsonbEach, jsonbEachText: Return the fields of a JSON object as rows of a key and a value

jsonbObjectKeys: Return the keys of a JSON object as rows

jsonbPretty: Return the indented text of a JSON value

jsonbConcat: Concatenate two JSON values

jsonbDelete, jsonbDeleteArray, jsonbDeleteIndex, jsonbDeletePath: Delete a key, the keys of an array, an array element or the item at a path from a JSON value

jsonbExists, jsonbExistsAny, jsonbExistsAll: Does a text, or any or all the texts of an array, exist as a top-level key or array element of a JSON value?

jsonbContains, jsonbContained: Does the first JSON value contain, or is it contained in, the second one?

jsonbSet, jsonbSetLax: Return a JSON value with the item at a path set to a value

jsonbInsert: Return a JSON value with a value inserted at a path

jsonbStripNulls: Return a JSON value without its object fields whose value is null

jsonbPathExists, jsonbPathExistsTz: Does the JSON path return any item for a JSON value?

jsonbPathMatch, jsonbPathMatchTz: Return the result of a JSON path predicate check for a JSON value

jsonbPathQuery, jsonbPathQueryTz, jsonbPathQueryArray, jsonbPathQueryArrayTz, jsonbPathQueryFirst, jsonbPathQueryFirstTz: Return the items a JSON path returns for a JSON value, as rows, as a JSON array, or the first one

eq, cmp, hash, hashExtended: Compare two JSON values, or return the hash value of a JSON value

->, ->>, 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, jsonbFromText, jsonpathFromText: 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

::: Convert a temporal JSONB to a tstzspan

::: Convert between a temporal JSONB and a text

::: Convert between a temporal JSONB and a temporal text

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

tgeompoint, tgeogpoint, tgeometry, tgeography: Extract a temporal geo 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

tCount: Temporal count

wCount: Window count