Robert DiFalco <robert.difalco@gmail.com> 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