Quick Regex Question

Поиск
Список
Период
Сортировка
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 по дате отправления: