Using index for substring search - Mailing list pgsql-general

From Lec
Subject Using index for substring search
Date
Msg-id 3C8E8B4F.5900AF42@pc.jaring.my
Whole thread Raw
Responses Re: Using index for substring search  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Is it possible for postgreSQL 7.2 to use index search for the following
queries:

select name from item where substring(itemcode,1,3) = '101';
select name from item where itemcode like '101%';

if I have an index on itemcode.

Version 6.5.3 can use index search for the first query.

Thanks,
Thomas.


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: index on large table
Next
From: John Bell
Date:
Subject: System Tables Query