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

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 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-08-29 Thread Bruno Wolff III
On Mon, Aug 29, 2005 at 14:11:37 +0100, Julian Scarfe <[EMAIL PROTECTED]> wrote: > I'd like a regex that matches 'CD' but not 'ABCD' in any part of the regex. > > Is there a workaround that allows me to do this as a single regex? > > I know I could and together a ~ and !~ like this > > # selec

[SQL] Negative lookbehind assertions in regexs

2005-08-29 Thread Julian Scarfe
I'd like a regex that matches 'CD' but not 'ABCD' in any part of the regex. In Perl I'd use a negative lookbehind assertion (?Julian ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster