json mutate

test.sql

DROP TABLE IF EXISTS student;

CREATE TABLE student (
	id SERIAL PRIMARY KEY,
	name VARCHAR(255),
	state JSONB
);

INSERT INTO student (name, state) VALUES ('Bob', '{"completed": []}');

UPDATE student SET state = jsonb_set(state, '{completed}', state->'completed' || '[1,2,3]', TRUE) WHERE name = 'Bob';
UPDATE student SET state = jsonb_set(state, '{completed}', state->'completed' || '[4,5]', TRUE) WHERE name = 'Bob';

SELECT * FROM student;