I checked with SELECT VERSION(); and got: PostgreSQL 12.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit
tir. 9. apr. 2024 kl. 15:05 skrev Arne Sommerfelt <arne.sommerf...@gmail.com >: > 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 >> >
