Re: Quick Regex Question

[Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>]

On Thu, 20 Dec 2007 09:56:00 +0000
Howard Cole <howardnews(at)selestial(dot)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