title: Splitting characters after regexp_split_to_array
body: <pre><code>select name, (regexp_split_to_array(name, '')) from table
  </code></pre>
  
  <p>The result is <code>{a,b,c,d,e}</code>. Is it possible to split that up to individual rows and group by name so that it looks like:</p>
  
  <pre><code>a 1
  b 2
  c 3
  d 4
  e 5
  </code></pre>