Re: BUG #18809: Inconsistent JSON behavoir

On Wednesday, February 12, 2025, PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 18809
> Logged by: Mark Drake
> Email address: mark(dot)drake(at)golden-hind(dot)com
> PostgreSQL version: 17.0
> Operating system: Linux
> Description:
>
> broadway=#
> broadway=# select jsonb('[2,3,1]') - to_jsonb(1);
> ERROR: operator does not exist: jsonb - jsonb
> LINE 1: select jsonb('[2,3,1]') - to_jsonb(1);
> ^
> HINT: No operator matches the given name and argument types. You might
> need
> to add explicit type casts.
> broadway=#
>
> Given that the first statement show the array contains an element that
> matches to_jsonb(1) the fourth statement should delete the third ( index 2)
> item from the array, not return an argument type mismatch. This would solve
> the problem of not being able to delete from a JSON integer array by value
>
>
This would be a feature request, not a bug report.

Feature requests usually are better sent to the -general mailing list where
support and possible developers are more likely to be looking.

I do concur we seem to have a feature gap here.

David J.