How to insert into the new json value, the value of another column in an UPDATE query?

Question

PostgreSQL

Can you please tell me how to correctly specify subquery.email in this request?

UPDATE group_settings 
SET group_recepients='{"email": subquery.email, "telegram_token": "", "telegram_user_id":""}'
FROM (SELECT id, email from users) AS subquery WHERE group_settings.user_id = subquery.id;

Answer 1

Something like this

UPDATE group_settings 
SET group_recepients = jsonb_build_object('email', subquery.email, 'telegram_token', '', 'telegram_user_id', '')
FROM (SELECT id, email from users) AS subquery WHERE group_settings.user_id = subquery.id;

jsonb_build_object