Re: Problem with text_pattern_ops

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.