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])

Reply via email to