Function jsonb_strip_nulls

Source
fn jsonb_strip_nulls(v: JsonbRef<'_>) -> JsonbVal
Expand description

Recursively removes all object fields that have null values from the given JSON value. Null values that are not object fields are untouched.

Examples:

query T
SELECT jsonb_strip_nulls('[{"f1":1, "f2":null}, 2, null, 3]');
----
[{"f1": 1}, 2, null, 3]