Thread: Regexp group matching - extracting second group element?

Regexp group matching - extracting second group element?

From
Mario Splivalo
Date:
When doing group regexp matching, I can extract first group element,
using SUBSTR function, like this:

octopussy2=# select substring('wizzgame auction 24' from '\\W*(\\w*)[\
\s]+(.*)');substring
-----------wizzgame
(1 row)

So, i got 'wizzgame' as first group. Is there a way to extract 'auction
24' as a second group?
Mario
-- 
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."