Re: Postgres regexp matching failure? - Mailing list pgsql-sql

From Aaron Bono
Subject Re: Postgres regexp matching failure?
Date
Msg-id bf05e51c0609050910k226fe36frbbfbe14db34a6b9d@mail.gmail.com
Whole thread Raw
In response to Re: Postgres regexp matching failure?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-sql
On 9/5/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:

In Perl at least, \b is a word boundary.  In PostgreSQL (and probably
Tcl as well) it's a backslash AFAICT.

More specifically, Perl, Java and Python interpret \b as a backspace in the Character class only (got that from the Regular Expression pocket reference) but otherwise are word boundries.  I am not entirely sure what the Character class context is referring to but it does show that \b is interpreted differently under different contexts.  PostgreSQL may not have a way (or at least a very good way) to make this distinction.

Any other thoughts?

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

pgsql-sql by date:

Previous
From: "codeWarrior"
Date:
Subject: Re: Subquery alternatives?
Next
From: "Marc G. Fournier"
Date:
Subject: Way to reverse ordering of an IP ... ?