Robert DiFalco <robert.difalco@xxxxxxxxx> wrote: > I just have a single VARCHAR field for name, so the full name > "William S. Burroughs" is a single row and column. I want to as > simply as possible have the ability to search find this record > with Will, will, Burr, burroughs, etc. > As far as I can tell, the trigram extension would be the easiest > way to implement this. It looks like I wouldn't need to mess with > vectors, etc. It would just look like a standard index and query, > right? Right. For what you describe, I think the KNN searches using trigrams and a gist index sounds like the appropriate solution. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
