On 2/1/07, Jim Nasby <decibel@xxxxxxxxxxx> 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
