Regexp group matching - extracting second group element? - Mailing list pgsql-sql

From Mario Splivalo
Subject Regexp group matching - extracting second group element?
Date
Msg-id 1136902727.27803.3.camel@localhost.localdomain
Whole thread Raw
List pgsql-sql
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."




pgsql-sql by date:

Previous
From: David Ford
Date:
Subject: Re: system view corrupted, i get "unexpected right parenthesis" for many system tables.
Next
From: "Mauricio Fernandez A."
Date:
Subject: Unable to identify an ordering operator '<' for type 'smallint[]'