From: Glyn Astill Date: Sat, 24 Jan 2015 08:08:42 +0000 (+0000) Subject: Merge pull request #1 from schinckel/patch-1 X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Fpg_jsonb_delete_op;a=commitdiff_plain;h=259d9e7d60b9710204633bef44a478f163fb34db;hp=097d1712ac6bce8ffbca895101dacf8f33444e17 Merge pull request #1 from schinckel/patch-1 Remove two unnecessary operations. --- diff --git a/pg_jsonb_delete_op.sql b/pg_jsonb_delete_op.sql index 4f559c8..3a3c818 100755 --- a/pg_jsonb_delete_op.sql +++ b/pg_jsonb_delete_op.sql @@ -12,7 +12,7 @@ $BODY$ ( SELECT ('{' || string_agg(to_json(key) || ':' || value, ',') || '}') FROM jsonb_each(a) - WHERE NOT to_json(key)::jsonb ? b + WHERE key <> b ) , '{}')::jsonb; $BODY$