X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Fpg_jsonb_opx;a=blobdiff_plain;f=sql%2FREADME.md;fp=sql%2FREADME.md;h=0575f0d4176d9701dcb55f25b4400802bc202c9a;hp=0000000000000000000000000000000000000000;hb=bf6318c60bd05043800c698a6b14f6aaa17a4824;hpb=4182f8ab210feedbd7d146aa2c6c6fa77ba4962f diff --git a/sql/README.md b/sql/README.md new file mode 100755 index 0000000..0575f0d --- /dev/null +++ b/sql/README.md @@ -0,0 +1,25 @@ +jsonb_opx +========= + +Missing operators for jsonb in PostgreSQL 9.4, this may contain some errors and bad form as it's primarily just experimentation (i'm not a frequent C programmer; but everyone has to start somewhere right?). Please test that it suits your requirements before using in any production scenario. + +Provides +-------- + +The following behave like hstore 1.x operators, i.e. without nested jsonb traversal + +* deletion using **-** operator + * jsonb_delete(jsonb, text) + * jsonb_delete(jsonb, text[]) + * jsonb_delete(jsonb, jsonb) +* concatenation using **||** operator + * jsonb_concat(jsonb, jsonb) +* replacement using **=#** operator + * jsonb_replace(jsonb, jsonb) + +The following are intended to eventually function like hstore 2.0 operators + +* deletion at chained path using **#-** operator + jsonb_delete_path(jsonb, text[]) +* replacement at chained path using function + jsonb_replace_path(jsonb, text[], jsonb)