From a29ac77c075523cf1e885a4b5ade6249b82ec82a Mon Sep 17 00:00:00 2001 From: Florents Tselai Date: Tue, 17 Sep 2024 23:38:01 +0300 Subject: [PATCH v1 2/2] Add docs for strip_in_arrays argument --- doc/src/sgml/func.sgml | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 84eb3a45ee..5840d833d3 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -17119,25 +17119,31 @@ ERROR: value too long for type character(2) json_strip_nulls - json_strip_nulls ( json ) + json_strip_nulls ( target jsonb, ,strip_in_arrays boolean ) json jsonb_strip_nulls - jsonb_strip_nulls ( jsonb ) + jsonb_strip_nulls ( target jsonb, ,strip_in_arrays boolean ) jsonb Deletes all object fields that have null values from the given JSON value, recursively. Null values that are not object fields are untouched. + If strip_in_arrays is true (default is false), null array elements are also stripped. json_strip_nulls('[{"f1":1, "f2":null}, 2, null, 3]') [{"f1":1},2,null,3] - + + + jsonb_strip_nulls('[1,2,null,3,4]', true); + [1,2,3,4] + + -- 2.39.3 (Apple Git-146)