Vector Functions

Explore vector functions. This section details SQL functions for manipulating and querying vector data types, enabling efficient similarity search and AI/ML applications within your database.

VEC_DISTANCE

Calculate distance between vectors. This function computes the distance between two vectors using either Euclidean or Cosine metric, depending on the index.

VEC_DISTANCE_COSINE

Calculate Cosine distance. This function computes the Cosine distance between two vectors, measuring the cosine of the angle between them.

VEC_DISTANCE_EUCLIDEAN

Calculate Euclidean distance. This function computes the Euclidean (L2) distance between two vectors, representing the straight-line distance.

VEC_FromText

Convert text to vector. This function parses a JSON array string representation of a vector and converts it into the binary VECTOR data type.

VEC_ToText

Convert vector to text. This function takes a binary VECTOR data type and returns its JSON array string representation.

_{This page is licensed: CC BY-SA / Gnu FDL}