Hi Tom,
> Alex Krohn <alex(at)gossamer-threads(dot)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(at)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(at)penguin pgsql]$
Postmaster is running as user pgsql. Any ideas on workarounds?
Cheers,
Alex