title: SQLite: How to update rows with a sequence of numbers?
body: <p>In SQLIte I would like to renumber the values in a specific column with a sequence of numbers.
  For example the relevance-column in these rows:</p>
  
  <pre><code>relevance | value
  -------------------
  3         | value1
  5         | valueb
  8         | valuex
  9         | valueaa
  </code></pre>
  
  <p>must be updated starting from 1 with increment 1:</p>
  
  <pre><code>relevance | value
  -------------------
  1         | value1
  2         | valueb
  3         | valuex
  4         | valueaa
  </code></pre>
  
  <p>What I'm looking for, is something like this:</p>
  
  <pre><code>-- first set all to startvalue
  UPDATE MyTable SET relevance = 0; 
  -- then renumber:
  UPDATE MyTable SET relevance = (some function to increase by 1 to the previous row);
  </code></pre>
  
  <p>I tried this, but its not increasing, seems like Max is not evaluating on each row: </p>
  
  <pre><code>UPDATE MyTable SET relevance = (SELECT Max(relevance ))+1;
  </code></pre>