On 7/5/07, Artur Rataj <arturrataj@xxxxxxxxx> 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