Re: Like seems to fail ! - Mailing list pgsql-sql

Yves Martin <yma@elca.ch> writes:
> base=# select * from persistent_config where key like '/%';
>  key | type | value 
> -----+------+-------
> (0 rows)

What LOCALE are you running in?  There are some known problems with
LIKE index optimization in some non-ASCII locales.  If you drop
the index on persistent_config.key, does the problem disappear?
        regards, tom lane