Postgres Pro
Downloads
Home   >   mailing lists

Re: Can LIKE under utf8 use INDEXes? - Mailing list pgsql-general

From Tom Lane
Subject Re: Can LIKE under utf8 use INDEXes?
Date
Msg-id 2611.1248294675@sss.pgh.pa.us
Whole thread Raw
In response to Can LIKE under utf8 use INDEXes?  (Robert James <srobertjames@gmail.com>)
Responses Re: Can LIKE under utf8 use INDEXes?
List pgsql-general
Tree view 
Robert James <srobertjames@gmail.com> writes:
> Hi.  I'm confused about the behavior of LIKE under utf8 locale.

UTF8 is not a locale, it's an encoding.  If you're using C locale then
LIKE can use indexes, regardless of the encoding.  If you're using
some other locale then you need a pattern_ops index.

            regards, tom lane

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Best way to import data in postgresl (not "COPY")
Next
From: Andreas Wenk
Date:
Subject: Re: psql \du [PATCH] extended \du with [+] - was missing