FunctionsJSON

json_object_agg_unique

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

json_object_agg_unique(…) → JSON

Kind · aggregate

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

Part of the JSON family.

json_object_agg_strict

Builds a JSON object like json_object_agg but rejects NULL keys and NULL values.

json_object_agg_unique_strict

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