FunctionsJSON

json_object_agg_unique_strict

Builds a JSON object with unique keys and rejects NULL keys, NULL values, and duplicate-key collisions.

json_object_agg_unique_strict(…) → JSON

Kind · aggregate

Builds a JSON object with unique keys and rejects NULL keys, NULL values, and duplicate-key collisions.

Part of the JSON family.

json_object_agg_unique

Builds a JSON object and keeps the first value seen for each key, ignoring later duplicates.

json_object_field

Returns the value associated with a key in a JSON object.