On Tue, 26 Jul 2005, Joseph Shraibman wrote:
> 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.
I don't know how any locales I have access to handle separate accent
characters, but I think in theory at least, that handling may be different
than character by character comparison.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
