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

From Tom Lane
Subject Re: Postgres regexp matching failure?
Date
Msg-id 25029.1157469774@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres regexp matching failure?  (Mario Splivalo <mario.splivalo@mobart.hr>)
Responses Re: Postgres regexp matching failure?
List pgsql-sql
Mario Splivalo <mario.splivalo@mobart.hr> writes:
> So, I guess it's obvious that postgres doesn't treat regular expressions
> the same way as java/perl/pyton/php/awk/sed do...

When you get into stuff as arcane as word-boundary constraints, you'll
find that regexes are not NEARLY as well standardized as that flippant
complaint suggests.  For penance, actually try it in all six of those
languages and report back.

Postgres' regexp code is the same as Tcl's (it's Henry Spencer's package)
and if you check TFM you will find out that \y, or possibly \M, is what
you want.
        regards, tom lane


pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Postgres regexp matching failure?
Next
From: "codeWarrior"
Date:
Subject: Re: Subquery alternatives?