mirror of
https://github.com/pgvector/pgvector.git
synced 2026-06-29 01:01:17 +08:00
105 lines
2.0 KiB
Plaintext
105 lines
2.0 KiB
Plaintext
SELECT hamming_distance('111', '111');
|
|
hamming_distance
|
|
------------------
|
|
0
|
|
(1 row)
|
|
|
|
SELECT hamming_distance('111', '110');
|
|
hamming_distance
|
|
------------------
|
|
1
|
|
(1 row)
|
|
|
|
SELECT hamming_distance('111', '100');
|
|
hamming_distance
|
|
------------------
|
|
2
|
|
(1 row)
|
|
|
|
SELECT hamming_distance('111', '000');
|
|
hamming_distance
|
|
------------------
|
|
3
|
|
(1 row)
|
|
|
|
SELECT hamming_distance('10101010101010101010', '01010101010101010101');
|
|
hamming_distance
|
|
------------------
|
|
20
|
|
(1 row)
|
|
|
|
SELECT hamming_distance('', '');
|
|
hamming_distance
|
|
------------------
|
|
0
|
|
(1 row)
|
|
|
|
SELECT hamming_distance('111', '00');
|
|
ERROR: different bit lengths 3 and 2
|
|
SELECT hamming_distance('111', '000'::varbit(4));
|
|
hamming_distance
|
|
------------------
|
|
3
|
|
(1 row)
|
|
|
|
SELECT hamming_distance('111', '0000'::varbit(4));
|
|
ERROR: different bit lengths 3 and 4
|
|
SELECT jaccard_distance('1111', '1111');
|
|
jaccard_distance
|
|
------------------
|
|
0
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('1111', '1110');
|
|
jaccard_distance
|
|
------------------
|
|
0.25
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('1111', '1100');
|
|
jaccard_distance
|
|
------------------
|
|
0.5
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('1111', '1000');
|
|
jaccard_distance
|
|
------------------
|
|
0.75
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('1111', '0000');
|
|
jaccard_distance
|
|
------------------
|
|
1
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('1100', '1000');
|
|
jaccard_distance
|
|
------------------
|
|
0.5
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('10101010101010101010', '01010101010101010101');
|
|
jaccard_distance
|
|
------------------
|
|
1
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('', '');
|
|
jaccard_distance
|
|
------------------
|
|
1
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('1111', '000');
|
|
ERROR: different bit lengths 4 and 3
|
|
SELECT jaccard_distance('1111', '0000'::varbit(5));
|
|
jaccard_distance
|
|
------------------
|
|
1
|
|
(1 row)
|
|
|
|
SELECT jaccard_distance('1111', '00000'::varbit(5));
|
|
ERROR: different bit lengths 4 and 5
|