C locale

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

Responses

Browse pgsql-general by date

  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)