X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Fpg_jsonb_opx;a=blobdiff_plain;f=README.md;h=0eb0228397657205a3d08f5d7175aa0a25474438;hp=b1406e3fe0a03b2b9e172f3946c9da130e090940;hb=HEAD;hpb=4df8c5cd073dfd908019ebc307918b8e7102e0a6 diff --git a/README.md b/README.md index b1406e3..0eb0228 100755 --- a/README.md +++ b/README.md @@ -6,20 +6,44 @@ Missing operators for jsonb in PostgreSQL 9.4, this may contain some errors and Provides -------- -The following behave like hstore 1.x operators, i.e. without nested jsonb traversal +The following behave like **hstore 1.x operators**; i.e. without nested jsonb traversal * deletion using **-** operator * jsonb_delete(jsonb, text) + * jsonb_delete(jsonb, numeric) + * jsonb_delete(jsonb, boolean) * jsonb_delete(jsonb, text[]) + * jsonb_delete(jsonb, numeric[]) + * jsonb_delete(jsonb, boolean[]) * jsonb_delete(jsonb, jsonb) * concatenation using **||** operator * jsonb_concat(jsonb, jsonb) -* replacement using **=#** operator +* replacement using **#=** operator * jsonb_replace(jsonb, jsonb) -The following are intended to eventually function like hstor 2.0 operators +All of the above are provided with the standard extension and can be installed via CREATE EXTENSION E.g: + +```sql +CREATE EXTENSION jsonb_opx; +``` + +The following are intended to behave like **hstore 2.0 operators**; i.e. recurse into nested jsonb path. + +> As of 26/02/2015 there appears to be an effort discussed on pgsql-hackers for this type of path manipulation named jsonbx that appears to be much further ahead than my effort below. * deletion at chained path using **#-** operator - jsonb_delete_path(jsonb, text[]) -* replacement at chained path using function - jsonb_replace_path(jsonb, text[], jsonb) + * jsonb_delete_path(jsonb, text[]) +* replacement at chained path using function (no operator) + * jsonb_replace_path(jsonb, text[], jsonb) + +To install this extra functionality specify version 1.1 when using CREATE EXTENSION E.g: + +```sql +CREATE EXTENSION jsonb_opx VERSION '1.1'; +``` + +Or if you have version 1.0 already installed, use ALTER EXTENSION E.g: + +```sql +ALTER EXTENSION jsonb_opx UPDATE TO '1.1'; +```