mirror of
https://github.com/pgvector/pgvector.git
synced 2026-06-06 14:01:31 +08:00
22 lines
899 B
SQL
22 lines
899 B
SQL
SELECT hamming_distance('111', '111');
|
|
SELECT hamming_distance('111', '110');
|
|
SELECT hamming_distance('111', '100');
|
|
SELECT hamming_distance('111', '000');
|
|
SELECT hamming_distance('10101010101010101010', '01010101010101010101');
|
|
SELECT hamming_distance('', '');
|
|
SELECT hamming_distance('111', '00');
|
|
SELECT hamming_distance('111', '000'::varbit(4));
|
|
SELECT hamming_distance('111', '0000'::varbit(4));
|
|
|
|
SELECT jaccard_distance('1111', '1111');
|
|
SELECT jaccard_distance('1111', '1110');
|
|
SELECT jaccard_distance('1111', '1100');
|
|
SELECT jaccard_distance('1111', '1000');
|
|
SELECT jaccard_distance('1111', '0000');
|
|
SELECT jaccard_distance('1100', '1000');
|
|
SELECT jaccard_distance('10101010101010101010', '01010101010101010101');
|
|
SELECT jaccard_distance('', '');
|
|
SELECT jaccard_distance('1111', '000');
|
|
SELECT jaccard_distance('1111', '0000'::varbit(5));
|
|
SELECT jaccard_distance('1111', '00000'::varbit(5));
|