title: PostgreSQL regular expression capture group in select
body: <p>How can the matched regular expression be returned from an SQL select? I tried using <code>REGEXP_EXTRACT</code> with no luck (function not available). What I've done <em>that does work</em> is this:</p>
  
  <pre><code>SELECT column ~ '^stuff.*$'
  FROM table;
  </code></pre>
  
  <p>but this gives me a list of true / false. I want to know what is extracted in each case.</p>