title: postgresql: How to concatenate two regexp_matches()
body: <p>I'm trying to extract both ints and chars from names such as 123A America, 234B Britania.
  I only want the the number and the attached letter (i.e. 123A) .
  I'm using regexp_matches(name, '(\d+)(\D)') and it results as:</p>
  
  <p><code>{123,A}, 
  {456,B}</code></p>
  
  <p>I thought using concatenation, getting the first element of an array and the second element using two different functions
  <code>(regexp_matches(name, '(\d+)(\D)' )) [1] || (regexp_matches(name, '(\d+)(\D)' )) [2]</code></p>
  
  <p>But it generates an error:
  <code>ERROR:  functions and operators can take at most one set argument</code></p>
  
  <p>How can I get the two element as one string?</p>