From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problem with text_pattern_ops |
Date: | 2005-07-27 01:35:06 |
Message-ID: | 20050726183414.V67910@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dr NoName | 2005-07-27 02:15:43 | Re: transaction timeout |
Previous Message | DracKewl | 2005-07-27 00:50:15 | Re: Cursor Issue?? |