UPDATE items AS i SET
tg_file_id = c.file_id
FROM (values
(4001025902181,'AgACAgQAAx0ESyOiNgACARtfHXJ8WzXJlHzsAtMNHrHrrA-BFwAC5qoxG1g4jVCFBckS15ByoiWP4CJdAAMBAAMCAANtAAP2JwQAARoE')
) AS c(id, file_id)
WHERE i.item @> '{"id":c.id}'
Выдает error: invalid input syntax for type json
Колонка item типа jsonb (скриншот старый)и имеет вид
UPDATE items AS i SET
tg_file_id = c.file_id
FROM (values
(4001025902181,'AgACAgQAAx0ESyOiNgACARtfHXJ8WzXJlHzsAtMNHrHrrA-BFwAC5qoxG1g4jVCFBckS15ByoiWP4CJdAAMBAAMCAANtAAP2JwQAARoE')
) AS c(id, file_id)
WHERE (i.item->>'id')::bigint = c.id;