On Wed, Jul 22, 2009 at 5:57 PM, Robert James<srobertjames@gmail.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