jsonbx
- This Release
- jsonbx 1.0.0
- Date
- Status
- Stable
- Abstract
- Backport of PostgreSQL 9.5 JSONB features for 9.4
- Description
- PostgreSQL 9.5 comes with a bunch of new functions and operators for JSONB, including ||, json_set and json_delete. This extension makes them available to users of PostgreSQL 9.4
- Released By
- jberkus
- License
- PostgreSQL
- Resources
- Special Files
- Tags
Extensions
- jsonbx 1.0.0
- Extra JSONB functions and operators for PostgreSQL 9.4
README
jsonbx
As you know, PostgreSQL introduced Json(b) support at the 9.4 version, and hstore v2.0 saved in separate repository. But although PostgreSQL has this support at the core level, there are many useful functions, which wasn't ported to Json(b) from hstore v2.0 and json. Here is a review of the missing Json(b) functions, which will be implemented in this repo.
List of implemented functions
- jsonb_indent
- jsonb_concat
- jsonb_delete(jsonb, text)
- jsonb_delete_idx(jsonb, int)
- jsonb_delete_path(jsonb, text[])
- jsonb_set(jsonb, text[], jsonb, boolean)
List of implemented operators
- concatenation operator (||)
- delete key operator (jsonb - text)
- delete key by index operator (jsonb - int)
- delete key by path operator (jsonb - text[])
License
jsonbx is licensed under the same license as PostgreSQL itself
Contributors
jsonbx was created by Dmitry Dolgov portions written by Andrew Dunstan