I've been searching the list archives and the web for a while about which
locale is best used with PostgreSQL and I did not find a satisfactory answer
so I
thought I would ask the list.
Right now my locale is en_US, but with this you can not use standard indexes
for LIKE
queries, so I am left with two options:
1. User special 'operator class' indexes so that my non-C locale database
will use indexes
for like queries.
2. Reinitialize my database to use the C-locale (not a big deal since I am
still at a testing
phase of my project)..
I was just wondering if there is any thought as to what is the best
approach? By switching from en_US to C locales I can avoid using special
indexes,
but what do I lose? I don't really understand what the C locale is exactly,
so I'm not sure
if in switching from en_US to C to aviod using operator class indexes
something else
will stop working.
Thanks.
Ara Anjargolian
