>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