From: Tom Lane <tgl@sss.pgh.pa.us>
To: lucio.chiessi@trustly.com
cc: pgsql-bugs@lists.postgresql.org, Andrew Dunstan <andrew@dunslane.net>,
        Florents Tselai <florents.tselai@gmail.com>
Subject: Re: BUG #19409: Function jsonb_strip_nulls() changed from immutable to stable.
In-reply-to: <19409-e16cd2605e59a4af@postgresql.org>
References: <19409-e16cd2605e59a4af@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Fri, 13 Feb 2026 19:51:03 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <562480.1771013899.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 13 Feb 2026 15:18:19 -0500
Message-ID: <562481.1771013899@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/562481.1771013899%40sss.pgh.pa.us>
Precedence: bulk

PG Bug reporting form <noreply@postgresql.org> writes:
> ... this fails in PostgreSQL 18, because the jsonb_strip_nulls ( target
> jsonb [,strip_in_arrays boolean ] ) function changed from immutable to
> stable.

A bit of git excavation shows that this changed here:

Author: Andrew Dunstan <andrew@dunslane.net>
Branch: master Release: REL_18_BR [4603903d2] 2025-03-05 10:04:02 -0500

    Allow json{b}_strip_nulls to remove null array elements
    =

    An additional paramater ("strip_in_arrays") is added to these function=
s.
    It defaults to false. If true, then null array elements are removed as
    well as null valued object fields. JSON that just consists of a single
    null is not affected.
    =

    Author: Florents Tselai <florents.tselai@gmail.com>
    =

    Discussion: https://postgr.es/m/4BCECCD5-4F40-4313-9E98-9E16BEB0B01D@g=
mail.com

It looks like a thinko to me, because surely the strip_in_arrays
parameter did not make the function more mutable than before.
Nor did a quick search find any discussion of the point in the
thread.

			regards, tom lane