On Fri, Feb 02, 2007 at 12:00:27PM -0500, Merlin Moncure wrote: > 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. It looks like that's coming in 8.3 :) <http://archives.postgresql.org/pgsql-hackers/2007-02/msg00039.php> Cheers, D -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
