lvector_distance

Signature:

CREATE FUNCTION lvector_distance(v1 lvector_embedding, v2 lvector_embedding, metric LVARCHAR DEFAULT 'l2');

Purpose: Calculates distance or similarity between two lvector values using a metric such as l2, cosine, or dot/ip.

SELECT lvector_distance(
lvector_in('[1,2,3,4]'),
lvector_in('[1,2,3,4]'),
'l2'
) AS distance
FROM systables
WHERE tabid = 1;