Howard Cole wrote:
> 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.
No, it's searching for not-space, the ^ inverts the meaning of the
square brackets. You probably want something like '(^Ho)|( Ho)'
--
Richard Huxton
Archonet Ltd