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.