pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17472: Jsonb[] operations not working
2+ messages / 2 participants
[nested] [flat]
* BUG #17472: Jsonb[] operations not working
@ 2022-04-29 07:03 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2022-04-29 07:03 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: agarwal3akshay@gmail.com
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17472: Jsonb[] operations not working
@ 2022-04-29 09:40 Pavel Stehule <pavel.stehule@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Pavel Stehule @ 2022-04-29 09:40 UTC (permalink / raw)
To: agarwal3akshay@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-04-29 09:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-04-29 07:03 BUG #17472: Jsonb[] operations not working PG Bug reporting form <noreply@postgresql.org>
2022-04-29 09:40 ` Pavel Stehule <pavel.stehule@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox