On Wed, Dec 23, 2009 at 3:10 PM, Jamie Kahgee <jamie.kah...@gmail.com> wrote:
> what would be considered "best practice" for my situation?
> I have a table member, with column name that I want to put an index on,
> because it is searched quiet frequently. When I create my sql search string,
> the name will consist only of alpha-numeric characters and be compared
> against lowercase matches.

SNIP

> perhaps there is a solution that I haven't thought of.  any input would be
> appreciated!

look up full text search.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to