title: SQL update records with ROW_NUMBER()
body: <p>I have a table called 'cards', which has a column called 'position' 
  How can I update/set the 'position' to equal the row number of each record, using ROW_NUMBER()?</p>
  
  <p>I am able to query the records and get the correct values using this statement:</p>
  
  <pre><code>"SELECT *,  ROW_NUMBER() OVER () as position FROM cards"
  </code></pre>
  
  <p>So, I would like to do this but have it update the new values in the database.</p>