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

Reply via email to