From: Mario Splivalo <mario.splivalo@mobart.hr>
To: pgsql-sql@postgresql.org
Subject: Regexp group matching - extracting second group element?
Date: Tue, 10 Jan 2006 15:18:47 +0100
Message-ID: <1136902727.27803.3.camel@localhost.localdomain> (raw)
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."
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mario.splivalo@mobart.hr
Subject: Re: Regexp group matching - extracting second group element?
In-Reply-To: <1136902727.27803.3.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox