On Saturday, November 4, 2023, PG Doc comments form
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.
