Efficient String searching - Mailing list pgsql-admin

From Robert.Farrugia@go.com.mt
Subject Efficient String searching
Date
Msg-id OF2CFDB502.49ABF160-ONC1256AD2.0020E35E@go.com.mt
Whole thread Raw
Responses Re: Efficient String searching  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
Hi,

I have the following problem.  When doing string searches using the ilike
command, no indexes are being used.  This is giving performance problems,
whereas it takes longer to sequentially search the whole table.  Am i
missing something about searching for strings ?  Are there any efficient
methods than using regular expressions or like ?

Thanks
Robert




pgsql-admin by date:

Previous
From: david@netventures.com.au
Date:
Subject: pg_dump, ERROR: More than one tuple returned
Next
From: "Ales Vojacek"
Date:
Subject: Create DB on postgresql 7.1.3 on cygwin