On 7/5/07, Artur Rataj <arturrataj@gmail.com> wrote:
> But I want the server to use the C locale. I set the locale to C and
> run postmaster. I supposed it uses C locale, but -d 5 shows in log:
The locale for indexing is set during initdb:
initdb --no-locale
The ~ operator does consider using btree regardless of locale unless
your right hand term is a constant and you can reduce to a
(functional) boolean index...so ISTM you are looking in the wrong
place anyways...try tsearch2?
merlin