Why do the following three queries use different scan types under 7.1.2?
Under
6.5.3 they all used index (and my system ran MUCH faster, since I often
use the trailing %)
I've done a vacuum analyze.
I installed 7.1.2 on RedHat 6.2 using the RPMs.
anderson=# explain select value from s_n_grantor
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
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
RE: http://www.postgresql.org/idocs/index.php?functions-string.html
In Table 4-6. SQL String Functions and Operators
FUNCTIONRETURN TYPE DESC
...
substring( text extract
string substri
