jsonbx extension for PostgreSQL 9.4
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is 4 commits behind erthalion:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
expected
sql
.gitignore
.travis.yml
META.json
Makefile
README.md
jsonbx--1.0.sql
jsonbx.c
jsonbx.control
jsonbx.h
jsonbx_utils.c

README.md

Build Status

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