Postgres 15

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

CREATE TABLE testdata
    ("id" int, "Name" varchar(5), "Mobile" int, "jsonb_column" jsonb)
;
    
INSERT INTO testdata
    ("id", "Name", "Mobile", "jsonb_column")
VALUES
    (1, 'Name1', 123, '[{"2023-03-01": "false"}, {"2023-03-03": "false"}, {"2023-03-05": "false"}]'),
    (2, 'Name2', 234, '[{"2023-03-10": "false"}, {"2023-03-13": "false"}, {"2023-03-15": "false"}]'),
    (3, 'Name3', 456, '[{"2023-03-01": "false"}, {"2023-03-03": "false"}, {"2023-03-05": "false"}]')
;

CREATE TABLE



INSERT 0 3


WITH CTE AS
  (
SELECT "id", "Name", "Mobile",
  CASE WHEN (value->>'2023-03-01') ::BOOLEAN  = false  THEN
  jsonb_set(value,'{"2023-03-01"}','true'::jsonb,false)
  ELSE jsonb_set(value,'{"2023-03-01"}','false'::jsonb,false) END value
  FROM testdata
CROSS JOIN LATERAL jsonb_array_elements("jsonb_column")
  WHERE "Mobile" = 123),
  CTE2 as (
SELECT "id", "Name", "Mobile",jsonb_agg(value) as  "jsonb_column"
FROM CTE
GROUP BY "id", "Name", "Mobile")
UPDATE testdata
SET "jsonb_column" = CTE2."jsonb_column"
FROM CTE2
WHERE testdata.id = cte2.id

UPDATE 1


SELECT * FROM testdata


id
Name
Mobile
jsonb_column


2
Name2
234
[{"2023-03-10": "false"}, {"2023-03-13": "false"}, {"2023-03-15": "false"}]

3
Name3
456
[{"2023-03-01": "false"}, {"2023-03-03": "false"}, {"2023-03-05": "false"}]

1
Name1
123
[{"2023-03-01": true}, {"2023-03-03": "false"}, {"2023-03-05": "false"}]



SELECT 3

id	Name	Mobile	jsonb_column
2	Name2	234	[{"2023-03-10": "false"}, {"2023-03-13": "false"}, {"2023-03-15": "false"}]
3	Name3	456	[{"2023-03-01": "false"}, {"2023-03-03": "false"}, {"2023-03-05": "false"}]
1	Name1	123	[{"2023-03-01": true}, {"2023-03-03": "false"}, {"2023-03-05": "false"}]