FunctionsJSON

json_agg_strict

Collects non-NULL values in group order and returns a JSON array of their JSON-mapped tokens.

json_agg_strict(…) → JSON

Kind · aggregate

Collects non-NULL values in group order and returns a JSON array of their JSON-mapped tokens.

Part of the JSON family.

json_agg

Collects values in group order and returns a JSON array containing each JSON-mapped row value.

json_all_paths

Parses each JSON document and returns a JSON array of observed nested paths in dot-and-index notation.