title: update table with limit and offset in postgres
body: <p>hi is it possible to update a table with values form an other table with limit and offset?</p>
  
  <p>for example the table t_device has 600 rows
  and t_object has 100 rows</p>
  
  <p>i want to update a column but only the first 100 rows with an offset from a subquery  like</p>
  
  <pre><code>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;
  </code></pre>
  
  <p>is it possible? i cant find a solution to modive the value in t_device from t_object</p>
  
  <p>im using postgres 8.4</p>