Postgres 12

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?.

create function remove_element(p_input jsonb, p_to_remove jsonb)
  returns jsonb
as
$$
select coalesce(jsonb_agg(t.item order by t.idx), '[]')
from jsonb_array_elements(p_input) with ordinality as t(item, idx)
where t.item <> p_to_remove;
$$
language sql 
immutable;

CREATE FUNCTION

create table products (items jsonb);

insert into products
values 
  ('{"name": "Super name1","type": "Green","information": [{"name": "first","value": "high"},{"name": "second","value": "medium"}]}'),
  ('{"name": "Super name2","type": "Blue","information": [{"name": "second","value": "medium"}]}')
;

CREATE TABLE

INSERT 0 2

update products 
   set items = jsonb_set(items, '{information}', remove_element(items -> 'information', '{"name": "second", "value": "medium"}'));

UPDATE 2

select *
from products;

items

{"name": "Super name1", "type": "Green", "information": [{"name": "first", "value": "high"}]}

{"name": "Super name2", "type": "Blue", "information": []}

SELECT 2