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

From Mario Splivalo
Subject Re: Postgres regexp matching failure?
Date
Msg-id 1157465795.27799.37.camel@localhost.localdomain
Whole thread Raw
In response to Re: Postgres regexp matching failure?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Tue, 2006-09-05 at 10:11 -0400, Tom Lane wrote:
> Mario Splivalo <mario.splivalo@mobart.hr> writes:
> > Now, here is what happens if I try this in postgres:
> 
> > pulitzer2=# select '+mario' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$';
> 
> I'm thinking you've forgotten to double your backslashes.
> 

That was the first thing I tried :)

What confused me was the difference I get when using python, or perl, or
Java, or any other regexp 'matcher', therefore I asked for help here.
Mario
-- 
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres regexp matching failure?
Next
From: Mario Splivalo
Date:
Subject: Re: Postgres regexp matching failure?