Using index for "like 'ABC%'" type query - Mailing list pgsql-general

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 by date:

Previous
From: Jeffrey Melloy
Date:
Subject: 7.3 PDF documentation
Next
From: Jeffrey Melloy
Date:
Subject: Re: Using index for "like 'ABC%'" type query