Re: [SQL] Negative lookbehind assertions in regexs

2005-09-03 Thread Julian Scarfe
I'd like a regex that matches 'CD' but not 'ABCD' in any part of the regex. From: "Bruno Wolff III" <[EMAIL PROTECTED]> Something like: (^.?CD)|([^B]CD)|([^A]BCD) Thanks to Bruno, and to Dawid who replied offline. The above does the job nicely. Any plans for a Perl Compatible Regular Exp

Re: [SQL] Negative lookbehind assertions in regexs

2005-09-03 Thread Alvaro Herrera
On Sat, Sep 03, 2005 at 03:59:18PM +0100, Julian Scarfe wrote: > Any plans for a Perl Compatible Regular Expression operator? > http://www.pcre.org/ Why have Perl-Compatible things when you can have Perl itself? Just use plperl. > Or are two regex operators enough? Only two? We have not only

Re: [SQL] Negative lookbehind assertions in regexs

2005-09-03 Thread Dawid Kuroczko
On 9/3/05, Julian Scarfe <[EMAIL PROTECTED]> wrote: >> I'd like a regex that matches 'CD' but not 'ABCD' in any part of the>> regex.From: "Bruno Wolff III" <[EMAIL PROTECTED]>> Something like: > (^.?CD)|([^B]CD)|([^A]BCD)Thanks to Bruno, and to Dawid who replied offline.  The above does the jobnice