Re: [HACKERS] another locale problem

>This worked, however it made all selects of ~* '^sometext' sequential.

That's correct behavior.

>Why can't we use index searches in this case? I believe it is :-)

No. It's due to the nature of the Btree index.

>But this
>
>SELECT key FROM t WHERE key ~* '^ sometext';
>
>(note the space after the carret) still does not work! It says index scan will
>be used and finds nothng. If 'sometext' is all uppercase the proper result is
>returned. The problem seems to be in the regex handling anyway. I tried
>compiling regcomp.c with -funsigned-char, but that was not enough. Further
>hacking...

Again, that should not be index scan.

BTW, if you want to play with regex, you might find retest.c be
useful. You can build the test tool by:

make retest

enjoy:-)
--
Tatsuo Ishii