Using index for "like 'ABC%'" type query

Поиск
Список
Период
Сортировка
For current version of postgresql, is it possible for a query like below
to utilize an index?

select item_name from item where item_code like 'ABC%';

Earlier versions of postgresql, eg, 6.5.3 can utilize the index.


Thanks,
Thomas.


В списке pgsql-general по дате отправления: