Russell Smith <mr-russ@pws.com.au> writes:
> On Mon, 9 May 2005 09:20 am, Dan Harris wrote:
>> and ( recordtext like '%RED%' or recordtext like '%CORVETTE%' )
>>
> You cannot use an index for %CORVETTE%, or %RED%.
Not a btree index anyway. Dan might have some success here with a
full-text-indexing package (eg, contrib/tsearch2)
regards, tom lane