FunctionsJSON

json_concat

Concatenates two JSON values: objects are merged by key, arrays are concatenated, and mixed types are wrapped into arrays.

json_concat(…) → JSON

Kind · scalar

Concatenates two JSON values: objects are merged by key, arrays are concatenated, and mixed types are wrapped into arrays.

Part of the JSON family.

json_build_object

Builds a JSON object from alternating key/value arguments, converting each value to JSON.

json_delete

Deletes a top-level object key or array index and returns the updated JSON document.