Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE types(id UUID, elements JSONB);
INSERT INTO types VALUES(
    'e09292e0-f9ee-480b-ae56-c7a05fd355e9'::UUID,
    '[{"id": "260c7f69-bc8c-49c2-b65b-cb895da3aa2a", "type": 1}, {"id": "7e3211cb-8919-4941-b3d1-a7524493b03a", "type": 12}, {"id": "c4816652-ec62-4f83-aebd-1ec468d1d4a3", "type": 6}]'::JSONB
)
1 rows affected

SELECT elements FROM types


elements


[{"id": "260c7f69-bc8c-49c2-b65b-cb895da3aa2a", "type": 1}, {"id": "7e3211cb-8919-4941-b3d1-a7524493b03a", "type": 12}, {"id": "c4816652-ec62-4f83-aebd-1ec468d1d4a3", "type": 6}]


-- '!= ANY' CASE

UPDATE types
SET elements = (
    SELECT CASE
        WHEN jsonb_agg(element_obj) IS NULL THEN
            '[]'::JSONB
        ELSE
           jsonb_agg(element_obj)
     END
     FROM jsonb_array_elements(elements) AS t(element_obj)
     WHERE element_obj ->> 'id' != ANY(   -- '!= ANY'
          ARRAY [
            '260c7f69-bc8c-49c2-b65b-cb895da3aa2a',
            '7e3211cb-8919-4941-b3d1-a7524493b03a'
          ]::TEXT[]
      ) -- element_ids var
)
WHERE id = ANY(ARRAY ['e09292e0-f9ee-480b-ae56-c7a05fd355e9']::UUID[]) -- type_ids var
1 rows affected

SELECT elements FROM types


elements


[{"id": "260c7f69-bc8c-49c2-b65b-cb895da3aa2a", "type": 1}, {"id": "7e3211cb-8919-4941-b3d1-a7524493b03a", "type": 12}, {"id": "c4816652-ec62-4f83-aebd-1ec468d1d4a3", "type": 6}]


-- 'NOT IN' CASE

UPDATE types
SET elements = (
    SELECT CASE
        WHEN jsonb_agg(element_obj) IS NULL THEN
            '[]'::JSONB
        ELSE
           jsonb_agg(element_obj)
     END
     FROM jsonb_array_elements(elements) AS t(element_obj)
      WHERE element_obj ->> 'id' NOT IN(  -- 'NOT IN'
         SELECT * FROM UNNEST(
          ARRAY [
            '260c7f69-bc8c-49c2-b65b-cb895da3aa2a',
            '7e3211cb-8919-4941-b3d1-a7524493b03a'
          ]::TEXT[]
         )
      ) -- element_ids var
)
WHERE id = ANY(ARRAY ['e09292e0-f9ee-480b-ae56-c7a05fd355e9']::UUID[]) -- type_ids var
1 rows affected

SELECT elements FROM types


elements


[{"id": "c4816652-ec62-4f83-aebd-1ec468d1d4a3", "type": 6}]