Russell Smith <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
