PostgreSQL regular expression capture group in select : <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>
