我需要使用数字数组更新现有行。目前,我对引号的语法困惑(我认为是这个原因)。以下是我尝试过的查询...
测试1
WITH update_table_1 (id,column_b) AS
(VALUES (1,'{22}'), (72,'{29, 5}'))
UPDATE table_1 SET id = up.id, column_b = up.column_b FROM update_table_1 up
WHERE up.id = table_1.id;
测试2
WITH update_table_1 (id,column_b) AS
(VALUES (1,'{"22"}'), (72,'{"29","5"}'))
UPDATE table_1 SET id = up.id, column_b = up.column_b FROM update_table_1 up
WHERE up.id = table_1.id;
测试 3
WITH update_table_1 (id,column_b) AS
(VALUES (1,{22}), (72,{29, 5}))
UPDATE table_1 SET id = up.id, column_b = up.column_b FROM update_table_1 up
WHERE up.id = table_1.id;
测试4
WITH update_table_1 (id,column_b) AS
(VALUES (1,{22}), (72,{"29","5"}))
UPDATE table_1 SET id = up.id, column_b = up.column_b FROM update_table_1 up
WHERE up.id = table_1.id;
'{1,2}'::bigint[]
- Daniel Vérité