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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers