Обсуждение: jsonb array accessors

Поиск
Список
Период
Сортировка

jsonb array accessors

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/datatype-json.html
Description:

https://dbfiddle.uk/Dr-c-nqL

multiple subscripts for jsonb arrays do not behave as described on Table
8.25 in Postgres 16 docs / 8.14.7 jsonpath

Re: jsonb array accessors

От
"David G. Johnston"
Дата:
On Saturday, November 4, 2023, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/datatype-json.html
Description:

https://dbfiddle.uk/Dr-c-nqL

multiple subscripts for jsonb arrays do not behave as described on Table
8.25 in Postgres 16 docs / 8.14.7 jsonpath

That table describes jsonpath operations.  Your example doesn’t involve jsonpath at all; it uses an SQL-scoped operation/syntax.

You will need to use an operator or function that accepts jsonpath as its argument if you want to avail yourself of jsonpath functionality.

David J.