Home > mailing lists

Similarity check on vectors - Mailing list pgsql-novice

From	Shmagi Kavtaradze
Subject	Similarity check on vectors
Date	February 9, 2016 18:42:27
Msg-id	CAHY6mayfao+9hc=2u3v2w1TdFPGuORPZxcgXv0w5b054wDGVLg@mail.gmail.com Whole thread Raw
List	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?

From: "Griffin, Jimmy (NIH/NIAID) [C]"
Date: 08 February 2016, 23:12:45
Subject: How to use pg_ldap_sync

From: Tim Sailer
Date: 11 February 2016, 20:30:32
Subject: Strange problem