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
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
