title: Postgresql: Update column1 with ascending values, depending on column2 sort order
body: <p>I have a table 'bride' with some string values like that:</p>
  
  <pre class="lang-none prettyprint-override"><code>id       name     order
  -------  -------  -------
  1        Beatrix 
  2        Bill 
  3        ORen
  4        Vernita
  5        Elle 
  6        Budd
  </code></pre>
  
  <p>I would like to update the column 'order' with the numbers (starting with 1) according to the order of sorting the 'name' column. Like that:</p>
  
  <pre class="lang-none prettyprint-override"><code>id       name     order
  -------  -------  -------
  1        Beatrix  1
  2        Bill     2
  3        ORen     5
  4        Vernita  6
  5        Elle     4
  6        Budd     3
  </code></pre>
  
  <p>My problem is how to use the sorted names as the order of inserting the actual order numbers. Any help would be great.</p>