FunctionsJSON

json_build_array

Constructs a JSON array from the function arguments for each row, preserving argument order.

json_build_array(…) → JSON

Kind · scalar

Constructs a JSON array from the function arguments for each row, preserving argument order.

Part of the JSON family.

json_array_length

Returns the number of top-level elements in the input JSON array.

json_build_object

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