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.