Re: [SQL] Postgres regexp matching failure?

[Aaron Bono]

On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:

pulitzer2=# select 'stop works' ~ '^\s*(?:[\
+|-]|(?:[sS][tT][oO][pP]\b)).*$';
?column?
----------
f
(1 row)

Here, postgres should return true, but it gives me false.

 

\b is a back-space - is that what you are wanting there?  If I remove it I get true.

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