Received: from mta06-svc.ntlworld.com (mta06-svc.ntlworld.com [62.253.162.46])
	by postgresql.org (Postfix) with ESMTP id B6058475B97
	for <pgsql-sql@postgresql.org>; Sat, 13 Jul 2002 14:18:06 -0400 (EDT)
Received: from Wilbur ([80.2.246.217]) by mta06-svc.ntlworld.com
	(InterMail vM.4.01.03.27 201-229-121-127-20010626) with SMTP
	id <20020713181806.MFMY4119.mta06-svc.ntlworld.com@Wilbur>;
	Sat, 13 Jul 2002 19:18:06 +0100
Message-ID: <016101c22a99$a9951d80$0500a8c0@Wilbur>
From: "Julian Scarfe" <julian@avbrief.com>
To: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
Cc: <pgsql-sql@postgresql.org>
References: <20020713082522.U19431-100000@megazone23.bigpanda.com>
Subject: Re: Indexes with LIKE
Date: Sat, 13 Jul 2002 19:18:18 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Archive-Number: 200207/214
X-Sequence-Number: 8592

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.

Julian Scarfe