BUG #17472: Jsonb[] operations not working

Hi

pá 29. 4. 2022 v 11:03 odesílatel PG Bug reporting form <
noreply@postgresql.org> napsal:

The following bug has been logged on the website:

Bug reference: 17472
Logged by: Akshay Agarwal
Email address: agarwal3akshay@gmail.com
PostgreSQL version: 14.2
Operating system: Windows
Description:

The jsonb[] type of columns are not supporting any kind of deletion
operations.
Since jsonb supports array of json objects, why jsonb[] was created? is
there any difference in the performance of the same?

This is not a bug. Arrays are supported for almost all types in Postgres.
It is a generic feature. Just json can hold arrays too, and from PostgreSQL
14 Postgres allows to use similar interface.

If jsonb arrays are faster than Postgres arrays? It depends on the task and
environment. The update of a jsonb array can have the same speed as an
update of a generic array in SQL, but generic arrays have special support
in PL/pgSQL, and there can be significant differences in performance.

Regards

Pavel