FunctionsVector

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.

negative_inner_product(…) → Float64

Kind · scalar

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.

Part of the Vector family.

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.

Window

12 Window functions in the NYXDB native function registry, with signatures, briefs, and measured medians where available.