FunctionsJSON

json_object_agg_strict

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

json_object_agg_strict(…) → JSON

Kind · aggregate

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

Part of the JSON family.

json_object_agg

Builds a JSON object by grouping key/value pairs; when the same key repeats, the last value wins.

json_object_agg_unique

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