Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Postgres regexp matching failure?
Date
Msg-id 24281.1157465504@sss.pgh.pa.us
Whole thread Raw
In response to Postgres regexp matching failure?  (Mario Splivalo <mario.splivalo@mobart.hr>)
Responses Re: Postgres regexp matching failure?  (Mario Splivalo <mario.splivalo@mobart.hr>)
List pgsql-sql
Tree view 
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.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: Postgres regexp matching failure?
Next
From: Mario Splivalo
Date:
Subject: Re: Postgres regexp matching failure?