Re: Problem with text_pattern_ops - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: Problem with text_pattern_ops
Date
Msg-id 42E6CC42.3060400@selectacast.net
Whole thread Raw
In response to Re: Problem with text_pattern_ops  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: Problem with text_pattern_ops
List 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 by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: Rules vs Triggers
Next
From: Stephan Szabo
Date:
Subject: Re: Problem with text_pattern_ops