Re: select fails on indexed varchars.

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?

            regards, tom lane