Skip site navigation (1) Skip section navigation (2)

LIKE.....and Locale

From: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: LIKE.....and Locale
Date: 2005-10-11 10:34:19
Message-ID: 1129026859.2792.20.camel@retsol1 (view raw or flat)
Thread:
Lists: pgsql-novice
PostgreSQL 8.0.3 Fedora Core4

I have moved a database from 7.4.5 to 8.0.3. My land setting when
initdb'ing the 8.0.3 cluster was:
LANG=en_US.UTF-8

>From recollection, under 7.4.5 my collate sequence etc in the config
(although commented out) was 'C'.
The issue is under 7.4.5 the LIKE 'A%' used indexes to find data - under
the new 8.0.3 database it doesn't. Two questions: 1) should LIKE 'A%'
use an index under the en_US locale? 2) if not is the only way to
correct this is to export the databases, re init with a different locale
('C'?) and then restore?

Regards,

Steve Tucknott
ReTSol Ltd

DDI: 01903 828769
Mobile: 0773 671 5772

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-10-11 13:47:31
Subject: Re: LIKE.....and Locale
Previous:From: Paresh BafnaDate: 2005-10-11 07:14:50
Subject: Multi-relation/column keyword indices

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group