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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
