Re: [HACKERS] another locale problem

> >>>Tatsuo Ishii said:
>  > > SELECT key FROM t WHERE key ~* '^somestring'
>  > > 
>  > > returns no tuples and explain says it will use the index on key. Why is th
>      is?
>  > 
>  > That's strange. It should be seq scan in this case?
> 
> I forgot to mention, that if 'somestring' is all uppercase, everything works 
> (the key field in the table is all uppercase). It still says index scan will 
> be used.
> 
> 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';

Oops, forgot ~* is case-insensitive.  The conditions we adde for this
require the query to be between > A and < a, which is not very
restrictive.

No real better way to do this.


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610) 853-3000 +  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026