Re: Can LIKE under utf8 use INDEXes?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Robert James <srobertjames(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can LIKE under utf8 use INDEXes?
Date: 2009-07-22 18:37:41
Message-ID: 407d949e0907221137o3689cd55gd6040a1d0ccdd052@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 22, 2009 at 5:57 PM, Robert James<srobertjames(at)gmail(dot)com> wrote:
> Hi.  I'm confused about the behavior of LIKE under utf8 locale.
> Accoding to the docs (
> http://www.postgresql.org/docs/8.2/interactive/locale.html - excerpted
> below), it seems that LIKE ignores locale and hence can't use indexes.  Yet,
> EXPLAIN clearly shows it using indexes.

Are you sure you're using 8.2?

--
greg
http://mit.edu/~gsstark/resume.pdf

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2009-07-22 18:49:46 Re: Can LIKE under utf8 use INDEXes?
Previous Message Denis BUCHER 2009-07-22 18:24:22 Best way to import data in postgresl (not "COPY")