By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
with data as (
select '{"id": 1, "name": "bar"}'::jsonb new, '{"id": 1, "name": "foo"}'::jsonb old
)
select new - old
from data;
ERROR: operator does not exist: jsonb - jsonb LINE 4: select new - old ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
with data as (
select 'id=>1, name=>bar'::hstore new, 'id=>1, name=>foo'::hstore old
)
select new - old
from data;
| ?column? |
|---|
| "name"=>"bar" |
SELECT 1