Re: jsonb array-style subscripting - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: jsonb array-style subscripting
Date
Msg-id 20150817194146.GB5232@alvherre.pgsql
Whole thread Raw
In response to jsonb array-style subscripting  (Dmitry Dolgov <9erthalion6@gmail.com>)
List pgsql-hackers
Dmitry Dolgov wrote:

> Some time ago the array-style subscripting for the jsonb data type was
> discussed in this mailing list. I think it will be quite convenient to have
> a such nice syntax to update jsonb objects, so I'm trying to implement
> this. I created a patch, that allows doing something like this:


> =# update test_jsonb_subscript set test_json['a']['a1']['a2'] = 42;

FWIW we discussed exactly this during the unconference
https://wiki.postgresql.org/wiki/PgCon_2015_Developer_Unconference#Direction_of_json_and_jsonb
and Andrew and Tom seemed okay with this syntax.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: checkpointer continuous flushing
Next
From: Peter Geoghegan
Date:
Subject: Re: jsonb array-style subscripting