| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Robert DiFalco <robert(dot)difalco(at)gmail(dot)com>, Jonathan Vanasco <postgres(at)2xlp(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: String searching |
| Date: | 2014-11-18 20:35:20 |
| Message-ID: | 181358803.1586622.1416342920775.JavaMail.yahoo@jws100104.mail.ne1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Robert DiFalco <robert(dot)difalco(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Vanasco | 2014-11-18 23:35:44 | issue with double ordering in a wrapped distinct |
| Previous Message | Vick Khera | 2014-11-18 18:01:34 | Re: String searching |