C locale
От | Ara Anjargolian |
---|---|
Тема | C locale |
Дата | |
Msg-id | 000501c4003a$08b50240$6401a8c0@ARA обсуждение исходный текст |
Ответы |
Re: C locale
Re: C locale Re: C locale |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: