Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries? - Mailing list pgsql-general

Dear experts,

I have the following query:

select * from notafiscal where numeroctc like ‘POA%34345’;

Prefix is normally 3 characters, suffix varyies.

Is Postgresql 9.0.4 able to use an BTREE index on notafiscal.numeroctc to execute this query?

Should I create GIST index or something else to speed up the query?

Thanks,

www.simkorp.com.br