FunctionsJSON

json_merge_patch

Applies a JSON Merge Patch (RFC 7396) document to a target JSON value and returns the patched result. Use this for partial updates of JSON objects.

json_merge_patch(…) → JSON

Kind · scalar

Applies a JSON Merge Patch (RFC 7396) document to a target JSON value and returns the patched result. Use this for partial updates of JSON objects.

Part of the JSON family.

json_length

Returns the number of top-level elements for arrays and top-level keys for objects. For scalar JSON values, returns 0.

json_object

Builds a JSON object from key/value arguments. Keys are interpreted as strings; values are converted to JSON using the engine's JSON mapping rules.