jsonbx extension for PostgreSQL 9.4
Clone or download
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 Jsonb 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 implemented for Jsonb, particularly there are not so many functions and operators for manipulation with jsonb. This repo will accumulate the implementation such kind of functions. Part of this functionality was already incorporated into PostgreSQL 9.5 (see this commit).

List of implemented functions

  • jsonb_pretty (in 9.5)
  • jsonb_concat (in 9.5)
  • jsonb_delete(jsonb, text) (in 9.5)
  • jsonb_delete_idx(jsonb, int) (in 9.5)
  • jsonb_delete_path(jsonb, text[]) (in 9.5)
  • jsonb_set(jsonb, text[], jsonb) (in 9.5)

List of implemented operators

  • concatenation operator (||) (in 9.5)
  • delete key operator (jsonb - text) (in 9.5)
  • delete key by index operator (jsonb - int) (in 9.5)
  • delete key by path operator (jsonb - text[]) (in 9.5)

License

jsonbx is licensed under the same license as PostgreSQL itself

Contributors

jsonbx was created by Dmitry Dolgov portions written by Andrew Dunstan