jsonb_build_array ( VARIADIC "any" ) → jsonbBuilds a possibly-heterogeneously-typed JSON array out of a variadic argument list. Each argument is converted as per
to_json or to_jsonb.json_build_array(1, 2, 'foo', 4, 5) → [1, 2, "foo", 4, 5]
FUNCTIONS / JSON FUNCTIONS AND OPERATORS
jsonb_build_array
Read PG 18 manual ↗Builds a possibly-heterogeneously-typed JSON array out of a variadic argument list.
Signatures & examples
Version history 2
- PG 12 → 13changed
- PG 9.4 → 9.5added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source