Robert Berger <[EMAIL PROTECTED]> writes:
> Why do the following three queries use different scan types under 7.1.2?
As Peter points out, index optimization of LIKE queries is disabled
unless your database is in C locale (if you're not sure,
contrib/pg_controldata can tell you what locale your da
Thanks. How do I set the locale?
> In 7.1, LIKE optimization (i.e., possibly using an index) has been
> disabled unless you are in the C locale because it does not work
> correctly. You could set your locale to C and re-initdb to get it to work
> again.
>
> --
> Peter Eisentraut [EMAIL PROTEC
