Hubert (depesz) Lubaczewski • 3/13/2025

Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements

This technical article details a new feature committed for PostgreSQL 18. It explains how the jsonb_strip_nulls and json_strip_nulls functions now accept an optional 'strip_in_arrays' parameter. When set to true, the function removes null elements from JSON arrays in addition to null-valued object fields, with examples demonstrating its behavior on nested structures.

0 comments

#json #functions #database

$Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements$