On Wed, Dec 23, 2009 at 3:10 PM, Jamie Kahgee <jamie.kahgee@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
