Re: select fails on indexed varchars. - Mailing list pgsql-bugs

Hi Tom,

> Alex Krohn <alex@gossamer-threads.com> writes:
> >         links=# select * from foo where a like 'Test/%'
> >         links-# ;
> >          a
> >         ---
> >         (0 rows)
>
> This looks like an artifact of the known problems with LIKE index
> optimization in non-ASCII locales.  What locale are you running the
> postmaster in?

Is this what you are looking for:

[postgres@penguin pgsql]$ locale
LANG=en_US
LC_CTYPE="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_COLLATE="en_US"
LC_MONETARY="en_US"
LC_MESSAGES="en_US"
LC_ALL=en_US
[postgres@penguin pgsql]$

Postmaster is running as user pgsql. Any ideas on workarounds?

Cheers,

Alex