LC_COLLATE and index usage

From: "Forest Wilkinson" <lyris-pg(at)tibit(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: LC_COLLATE and index usage
Date: 2003-05-07 22:34:24
Message-ID: k71jbvo3j70mbdfpumf25r95qt9a2vm7kr@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

According to the postgres 7.3.2 docs, initializing a database cluster
with LC_COLLATE set to anything other than "C" will disable the use of
indexes during LIKE searches. This presents a bit of a problem for
me, since the client application I'm writing uses LIKE searches and
ships internationally. As I understand it, I can have good
performance, or locale-specific ORDER BY output, but not both. Is
there a plan to remove this limitation?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Forest Wilkinson 2003-05-07 22:53:01 How to determine a database cluster's LC_COLLATE setting?
Previous Message jose arias 2003-05-07 21:53:30 bpchar_name