Tom Lane wrote:
> Madison Kelly <linux@alteeve.com> writes:
>
>> Can anyone see why the index might not be being used?
>
>
> You didn't initdb in 'C' locale. You can either re-initdb,
> or create a specialized index with a non-default operator class
> to support LIKE. See the documentation.
>
> regards, tom lane
I'll look into the non-default op class. I want to keep anything that
tweaks the DB in my code so that a user doesn't need to modify anything
on their system.
Thanks!
Madison
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Madison Kelly (Digimer)
TLE-BU, The Linux Experience; Back Up
http://tle-bu.thelinuxexperience.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-