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('-1001292939538'::text, array_to_json('{}'::bigint[])) WHERE user_id = 5242643274; SELECT * FROM users_info; UPDATE users_info SET bundle = bundle || jsonb_build_object('-1001292939538'::text, bundle->'-1001292939538'::text || '-1001292939538') WHERE user_id = 5242643274; SELECT * FROM users_info; UPDATE users_info SET bundle = bundle || jsonb_build_object('-1001292939538'::text, (bundle->'-1001292939538'::text) - '-1001292939538') WHERE user_id = 5242643274; SELECT * FROM users_info;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear