Re: Can LIKE under utf8 use INDEXes? - Mailing list pgsql-general

From Tom Lane
Subject Re: Can LIKE under utf8 use INDEXes?
Date
Msg-id 5356.1248306581@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can LIKE under utf8 use INDEXes?  (Andreas Wenk <a.wenk@netzmeister-st-pauli.de>)
List pgsql-general
Andreas Wenk <a.wenk@netzmeister-st-pauli.de> writes:
> Robert James wrote:
>> Thanks - I don't show any locale:

> ahm - you are running pg 8.2. There I think the + option is not
> available (\l+). So if you use a debian based system and installed it
> via the package manager apt or aptitude you could give this a try:

> /usr/lib/postgresql/8.2/bin/pg_controldata \
> /var/lib/postgresql/8.2/main/ |grep LC

Easier way is "SHOW LC_COLLATE" and "SHOW LC_CTYPE" ...

            regards, tom lane

pgsql-general by date:

Previous
From: Andreas Wenk
Date:
Subject: Re: Can LIKE under utf8 use INDEXes?
Next
From: Robert James
Date:
Subject: Help using SELECT INTO to make schema