SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table users_info ( user_id bigint not null, bundle jsonb default '{}'::jsonb not null ); INSERT INTO users_info (user_id) VALUES (5242643274); SELECT * FROM users_info; UPDATE users_info SET bundle = bundle || jsonb_build_object('1'::text, array_to_json('{}'::bigint[])) WHERE user_id = 1234; SELECT * FROM users_info; UPDATE users_info SET bundle = bundle || jsonb_build_object('1'::text, bundle->'1'::text || '2') WHERE user_id = 1234; SELECT * FROM users_info; UPDATE users_info SET bundle = bundle || jsonb_build_object('1'::text, (bundle->'1'::text) - '2') WHERE user_id = 1234; SELECT * FROM users_info;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear