FunctionsVector

l2_distance

Computes sqrt(sum_i (a_i - b_i)^2) over two equal-length array(float64) embeddings encoded as JSON-array text. Range [0, inf). Length mismatch yields NULL.

l2_distance(…) → Float64

Kind · scalar

Computes sqrt(sum_i (a_i - b_i)^2) over two equal-length array(float64) embeddings encoded as JSON-array text. Range [0, inf). Length mismatch yields NULL.

Part of the Vector family.

inner_product

Computes sum_i a_i * b_i over two equal-length array(float64) embeddings encoded as JSON-array text. Length mismatch yields NULL. For maximum-inner-product ANN ordering, use negative_inner_product …

negative_inner_product

Computes -sum_i a_i * b_i over two equal-length array(float64) embeddings encoded as JSON-array text, so ORDER BY ranks the largest dot product (most similar) first. Length mismatch yields NULL.