I am running on AWS RDS - it says engine version 12.17 i thought that was the postgres version. If so, the [] subscripting should be supported according to docs.
Arne tir. 9. apr. 2024 kl. 13:16 skrev Laurenz Albe <laurenz.a...@cybertec.at>: > On Tue, 2024-04-09 at 09:31 +0000, PG Doc comments form wrote: > > Page: https://www.postgresql.org/docs/16/datatype-json.html > > > > Using subscripts with square brackets is not supported, one must use -> > or > > #> operators > > The given examples result in error: > > > > SELECT ('{"a": 1}'::jsonb)['a']; > > > > -- Extract nested object value by key path > > SELECT ('{"a": {"b": {"c": 1}}}'::jsonb)['a']['b']['c']; > > > > -- Extract array element by index > > SELECT ('[1, "2", null]'::jsonb)[1]; > > You must be using an old PostgreSQL version where that is not yet > supported. > > Yours, > Laurenz Albe >
