Similarity check on vectors

From: Shmagi Kavtaradze <kavtaradze(dot)s(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Similarity check on vectors
Date: 2016-02-09 15:42:17
Message-ID: CAHY6mayfao+9hc=2u3v2w1TdFPGuORPZxcgXv0w5b054wDGVLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I was using pg_similarity on texts, but now I have two types of vectors:
bag of words and embedding vectors. They look like:

Bag of words: (delimited by comma or by space)
1,1,0,0,1

Embedding Vectors: (delimited by space)
-0.00205523529412 0.00168023529412 -0.00357188235294 -0.000664294117647
0.00369488235294

pg_similarity as other similarity check algorithms I saw work on text not
on Vectors. Any ideas how to do it or what extensions exist for this?

Browse pgsql-novice by date

  From Date Subject
Next Message Tim Sailer 2016-02-11 17:27:57 Strange problem
Previous Message Griffin, Jimmy (NIH/NIAID) [C] 2016-02-08 20:12:33 How to use pg_ldap_sync