Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE users (
  settings jsonb
);

insert into users values
('[
        {
            "id": 100,
            "name": "testOne",
            "settings": "settingOne"
        },
        {
            "id": 101,
            "name": "testTwo",
            "settings": "settingTwo"
        }
]');

CREATE TABLE



INSERT 0 1


update users
set settings = 
    settings  - (
    select coalesce(
       (select position::int-1 as index
        from jsonb_array_elements(settings) 
        with ordinality arr(elem, position) 
        WHERE elem->>'id' = '100'
        LIMIT 1
       ), 
       jsonb_array_length(settings))
   )

UPDATE 1


select *
from users;


settings


[{"id": 101, "name": "testTwo", "settings": "settingTwo"}]



SELECT 1