Quick Regex Question - Mailing list pgsql-general

From Howard Cole
Subject Quick Regex Question
Date
Msg-id 476A3C30.3060801@selestial.com
Whole thread Raw
Responses Re: Quick Regex Question
Re: Quick Regex Question
Re: Quick Regex Question
List pgsql-general
Hi all,

I don't understand the last result:

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

 From my limited experience of regex, the last one is searching for either
    'Ho' preceeeded by space or
    'Ho' at the beginning of a string.

How come it returns false?

Thanks.

P.S. The Ho's are Santa type Ho's - Not the other kind.

pgsql-general by date:

Previous
From: Wolfgang Keller
Date:
Subject: Re: Composite types for composite primary/foreign keys?
Next
From: Florian Aumeier
Date:
Subject: Re: Quick Regex Question