On Fri, Feb 02, 2007 at 12:00:27PM -0500, Merlin Moncure wrote:
> On 2/1/07, Jim Nasby <decibel@decibel.org> wrote:
> >Have you thought about something like ~
> >'(first_string|second_string| third_string)'? Obviously your
> >example would be more complex, but I believe that with careful
> >crafting, you can get regex to do a lot without resorting to
> >multiple passes.
>
> that doesn't work...i researched the problem further and found that
> postgresql regex implementation has the built in limitation to quit
> scanning after the first matched group (this is noted in the
> documentation). There is no way that I can see to extract two or
> more non contiguous text chunks in a single regex.
>
> To do it properly, you need to have the sophistication of perl regex
> with it's magic variables.
It looks like that's coming in 8.3 :)
<http://archives.postgresql.org/pgsql-hackers/2007-02/msg00039.php>
Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
