SELECT FROM tan-target
Before you begin
- SELECT examples
- SELECT statement
- TANIMOTO_COEFFICIENT function
- CREATE TABLE tan-target
- INSERT INTO tan-target
SELECT using TANIMOTO_COEFFICIENT() function
SELECT *, tanimoto_coefficient (stuff, ['milk', 'chocolate', 'cookies', 'cup'])
AS
distance
FROM
tan-target
ORDER BY distance;
_id | stuff | distance
-----+----------------+----------
2 | "cup,plate" | 0.2
1 | "cookies,milk" | 0.5