Re: Problem with text_pattern_ops

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: Problem with text_pattern_ops
Дата
Msg-id 42E6CC42.3060400@selectacast.net
обсуждение исходный текст
Ответ на Re: Problem with text_pattern_ops  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Ответы Re: Problem with text_pattern_ops  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-general

Stephan Szabo wrote:

> It is for the operators ~<~, ~<=~, ~=~, ~>=~, ~>~ (for like optimization).
> The docs seem to say that it does a character by character comparison
> rather than one using the collation thus being better for pattern
> matching. I'd think letting it do <, <=, =, >=, > would have it giving the
> wrong results for such queries (well, in non-C locales).

Well maybe queries of > < shouldn't be allowed because they would return
the wrong results, but surely equals is equals.

В списке pgsql-general по дате отправления:

Предыдущее
От: Roman Neuhauser
Дата:
Сообщение: Re: Rules vs Triggers
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Problem with text_pattern_ops