title: Postgresql "update query returning *" with limit
body: <p>Can I run an update query with return clause and also limit the rows returned? For example I run an udate query and it updates a million records, but I dont want to get the updated million rows back to result set.. just a sample say 1000 records. Is this possible?</p>
  
  <p>My Query :</p>
  
  <pre><code>UPDATE table1 SET col1 = value1 RETURNING *
  </code></pre>
  
  <p>I want to get the number of columns updated and a sample 1000 rows after update.</p>