Access to the fields and elements of JSONB sets and of temporal JSONB values, the existence of keys, the JSON path queries and the deletion of a path. Each function takes the prefix of the type of its first argument, jsonbset or tjsonb.
| Category | Operator | Portable function |
|---|---|---|
| JSON field / element access | -> | jsonbsetObjectField / tjsonbObjectField / jsonbsetArrayElement / tjsonbArrayElement (a, b) |
| ->> | jsonbsetObjectFieldText / tjsonbObjectFieldText / jsonbsetArrayElementText / tjsonbArrayElementText (a, b) | |
| JSON key existence | ? | jsonbsetExists / tjsonbExists (a, b) |
| ?& | jsonbsetExistsAll / tjsonbExistsAll (a, b) | |
| ?| | jsonbsetExistsAny / tjsonbExistsAny (a, b) | |
| JSON path | @? | jsonbsetPathExists / tjsonbPathExists (a, b) |
| @@ | jsonbsetPathMatch / tjsonbPathMatch (a, b) | |
| #- | jsonbsetDeletePath / tjsonbDeletePath (a, b) |