From: | "Ara Anjargolian" <ara(at)jargol(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | C locale |
Date: | 2004-03-02 09:37:50 |
Message-ID: | 000501c4003a$08b50240$6401a8c0@ARA |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Poslusny | 2004-03-02 10:20:07 | how to detect last change |
Previous Message | Tom Lane | 2004-03-02 04:54:11 | Re: Database metadata queries (WAS Re: Moving from MySQL to PGSQL....some questions) |