Re: [BUGS] select fails on indexed varchars.

[Alex Krohn]

Hi Tom,

> Alex Krohn <[EMAIL PROTECTED]> 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