例如,表t_device有600行
和t_object有100行

我想更新一个列,但只更新前100行与子查询的偏移量

update t_device set id_object = 
(select id_object from t_object limit 100) limit 100 offset 0;

update t_device set id_object = 
(select id_object from t_object limit 100) limit 100 offset 100;

可能吗？我无法找到一个解决方案来修改t_object中t_device中的值

我正在使用postgres 8.4

UPDATE t_device set id_object = t.id_object
FROM (select id_object from t_object order by id_object limit 100) t
WHERE t.id_object = t_device.id_object;