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