From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Daniel Kalchev <daniel(at)digsys(dot)bg> |
Cc: | t-ishii(at)sra(dot)co(dot)jp, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] another locale problem |
Date: | 1999-06-11 13:47:56 |
Message-ID: | 12078.929108876@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Daniel Kalchev <daniel(at)digsys(dot)bg> writes:
> To summarize the problem. If key contains (equivalent cyrillic
> letters) 'ABC', 'ABCD', 'DAB' and 'ABX' and the query is:
> SELECT key FROM t WHERE key ~* '^AB';
> index scan will be used and the correct tuples ('ABC', 'ABCD' and
> 'ABX') will be returned. If the query is
> SELECT key FROM t WHERE key ~* '^ab';
> index scan will be used and no tuples will be returned.
Hm. Is it possible that isalpha() is doing the wrong thing on your
machine? makeIndexable() currently assumes that isalpha() returns true
for any character that is subject to case conversion, but I wonder
whether that's a good enough test.
The other possibility is that regexp's internal handling of
case-insensitive matching is not right.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-06-11 13:49:51 | Re: [HACKERS] Re: locales and MB (was: Postgres 6.5 beta2 and beta3 problem) |
Previous Message | Horak Daniel | 1999-06-11 13:43:19 | missing #endif in win32 specific headers |