title: Extract only the first set of digits from Redshift/PostgreSQL
body: <p>I have below string in my RedShift column = col_name:</p>
  
  <blockquote>
    <p>Lorem ipsum dolor sit amet-80 consectetuer adipiscing elit. Aenean commodo ligula eget dolor,, 80  Cras dapibus. Vivamus elementum semper nisi. </p>
  </blockquote>
  
  <p>I just need the 1st digits extracted as new column. I tried</p>
  
  <pre><code>regexp_replace(item_name,'[^[:digit:]]') as new_col
  </code></pre>
  
  <p>but I get <code>8080</code>.</p>
  
  <p>How do I get just <code>80</code>?</p>