From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Julian Scarfe <julian@avbrief.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Indexes with LIKE
Date: Sun, 14 Jul 2002 12:46:53 -0700 (PDT)
Message-ID: <20020714124446.L31012-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <016101c22a99$a9951d80$0500a8c0@Wilbur>
On Sat, 13 Jul 2002, Julian Scarfe wrote:
> From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
>
> > You need to have made the database in C locale in order to get index scans
> > from LIKE. I think that's mentioned in the Localization section of the
> > admin guide, but I could be remembering that wrong.
>
> Thanks very much Stephan. Indeed it's in Admin Guide 5.1.2. I was using
> en_GB, not C.
>
> There is of course no excuse for failing to read every bit of smallprint in
> the admin guide before installation :-) but for those lazy unfortunates like
> me that don't think to look there to find out what's wrong when indexes
> aren't used with LIKE, I've added a DocNote under Pattern Matching.
That's a good idea. Alot of the docs are written assuming that you're
configuring it from source so that you'd have to turn on locale at
configure time, but that's not true for package users.
Are you actually using any of the locale features of the locale? If not,
you might want to consider setting up in C locale.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, julian@avbrief.com
Subject: Re: Indexes with LIKE
In-Reply-To: <20020714124446.L31012-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox