Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?

Andreas Joseph Krogh <andreak@officenet.no> writes:
> Anybody knows if the following query will use an index-scan in PG-8.3?
> SELECT name FROM person WHERE name LIKE 'and%';
> I know this works in "C"-locale, but I need it with UTF-8,

"C locale" and "UTF8" are entirely orthogonal things.
        regards, tom lane