|From:||Andrew Dunstan <andrew(at)dunslane(dot)net>|
|Subject:||mogrify and indent features for jsonb|
|Views:||Raw Message | Whole Thread | Download mbox|
Attached is a patch to provide a number of very useful facilities to
jsonb that people have asked for. These are based on work by Dmitry
Dolgov in his jsonbx extension, but I take responsibility for any bugs.
The facilities are:
concatenation: jsonb || jsonb -> jsonb
deletion: jsonb - text -> jsonb
deletion: jsonb - int -> text
produce indented text: jsonb_indent(jsonb) -> text
change an element at a path: jsonb_replace(jsonb, text, jsonb) -> jsonb.
It would be relatively trivial to add:
delete an element at a path: jsonb_delete(jsonb, text) -> json
and I think we should do that for the sake of completeness.
The docs might need a little extra work, and the indent code definitely
needs work, which I hope to complete in the next day or two, but I
wanted to put a stake in the ground.
|Next Message||Peter Eisentraut||2015-02-15 03:18:28||Add pg_settings.pending_restart column|
|Previous Message||David Steele||2015-02-15 02:34:52||Auditing extension for PostgreSQL (Take 2)|