Re: Quick Regex Question - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: Quick Regex Question
Date
Msg-id 20071220112543.4d462203@webthatworks.it
Whole thread Raw
In response to Quick Regex Question  (Howard Cole <howardnews@selestial.com>)
Responses Re: Quick Regex Question
List pgsql-general
On Thu, 20 Dec 2007 09:56:00 +0000
Howard Cole <howardnews@selestial.com> wrote:

> Hi all,
>
> I don't understand the last result:
>
> select 'Ho Ho Ho' ~* '^Ho'; returns true

There is actualli a Ho at the beginning of the string.

> select 'Ho Ho Ho' ~* ' Ho'; returns true

There are actually 2 ' Ho'

> select 'Ho Ho Ho' ~* '[^ ]Ho'; returns false (Please note there is
> a space between ^ and ])

There is no some character excluding space plus Ho.
What's missing is you're asking for some character before Ho.
The first Ho doesn't have a character preceding it.
The 2 other Ho have one... but it is a space and you don't want it.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: Marco Aurélio V. da Silva
Date:
Subject: Re: Problem with collector statistic
Next
From: Howard Cole
Date:
Subject: Re: Quick Regex Question