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.
merlin