JSONB Equality Operator

jsonb_equality_operator.sql

CREATE OR REPLACE FUNCTION jsonb_equality(left_arg jsonb, right_arg jsonb) 
RETURNS bool AS 
  $BODY$
    SELECT left_arg @> right_arg AND left_arg <@ right_arg;
  $BODY$ 
LANGUAGE SQL IMMUTABLE STRICT;
 
CREATE OPERATOR = (
  LEFTARG = jsonb,
  RIGHTARG = jsonb,
  PROCEDURE = jsonb_equality,
  NEGATOR = <>
);
 
SELECT '{}'::jsonb = '{}'::jsonb
$ TRUE
SELECT '{"a": "string", "b":2, "c": true}'::jsonb <> '{"c": false, "a": "string", "b":2}'::jsonb
$ TRUE
SELECT '{"a": "string", "b":2, "c": false}'::jsonb = '{"c": false, "a": "string", "b":2}'::jsonb
$ TRUE
SELECT '{"c":{"d": true}, "a":2}'::jsonb = '{"a":2, "c":{"d": true}}'::jsonb
$ TRUE
SELECT '{"c":{"d": true}, "a":2}'::jsonb <> '{"a":2, "c":{"d": true}}'::jsonb
$ FALSE