Re: Indexed leading substring searches - worked, now doesn't

Wes <wespvp@syntegra.com> writes:
> The locale is showing up as en_US.iso885915.  As far as I know, it was
> always this (default RedHat install), so I don't understand why it worked
> before.  Did something change between 7.4.1 and 7.4.5?  I supposed it's
> possible that I specified locale=C on the original database and don't
> remember that...

You got it in one ...

> I'm not going to have to "initdb --locale=C" and am I?

You could use the alternative operator classes for pattern searches, but
if you want the same indexes to also serve for normal text sorting,
C locale is the better bet.

            regards, tom lane