Re: LIKE.....and Locale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
Cc: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: LIKE.....and Locale
Date: 2005-10-11 13:47:31
Message-ID: 13631.1129038451@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Steve Tucknott <steve(at)retsol(dot)co(dot)uk> writes:
> 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?

No. See text_pattern_ops et al under
http://www.postgresql.org/docs/8.0/static/indexes-opclass.html

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Derrick Betts 2005-10-11 14:30:46 Re: delphi+adodb+postgresql+bytea
Previous Message Steve Tucknott 2005-10-11 10:34:19 LIKE.....and Locale