From: Aaron Bono <postgresql@aranya.com>
To: mario.splivalo@mobart.hr
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres regexp matching failure?
Date: Tue, 5 Sep 2006 08:42:38 -0500
Message-ID: <bf05e51c0609050642p590b8a7euc581ffd52119e4ce@mail.gmail.com> (raw)
In-Reply-To: <1157451491.27799.6.camel@localhost.localdomain>
References: <1157451491.27799.6.camel@localhost.localdomain>
On 9/5/06, Mario Splivalo <mario.splivalo@mobart.hr> 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.comhttp://codeelixir.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, mario.splivalo@mobart.hr
Subject: Re: Postgres regexp matching failure?
In-Reply-To: <bf05e51c0609050642p590b8a7euc581ffd52119e4ce@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox