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

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