| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Cory Tucker <cory(dot)tucker(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Grouping By Similarity (using pg_trgm)? |
| Date: | 2015-05-14 20:16:31 |
| Message-ID: | CAKFQuwauNdeqoT8dGukSHzsJ-vquz2Ewbv+5kKBFQ4KqNrRwig@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 14, 2015 at 1:09 PM, Cory Tucker <cory(dot)tucker(at)gmail(dot)com> wrote:
> That produces pretty much the same results as the CROSS JOIN I was using
> before. Because each "my_value" in the table are different, if I group on
> just their value then I will always have the full result set and a bunch of
> essentially duplicated results.
>
> Any other ideas/options?
>
>
how do you want to solve the problem:
A is similar to B
B is similar to C
A IS NOT similar to C
?
I'm not sure that PostgreSQL is the best tool to solve clustering
problems...though my experience with them is minimal.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis | 2015-05-14 20:26:45 | BDR table level replication questions |
| Previous Message | Cory Tucker | 2015-05-14 20:09:15 | Re: Grouping By Similarity (using pg_trgm)? |