Re: [SQL] Like seems to fail !

[Tom Lane]

Yves Martin <[EMAIL PROTECTED]> 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