Math Functions
The following list shows available mathematical functions:
| Name | Description |
|---|---|
| CEIL() | Return the smallest integer that is greater than or equal to a number |
| CEILING() | Same as CEIL() |
| COS() | Return cosine of a radian number |
| FLOOR() | Return the largest integer that is smaller than or equal to a number |
| PI() | Return the constant value of PI |
| POW() | Calculate power value |
| POWER() | Same as POW() |
| ROUND() | Return the round integer of a number |
| SIN() | Return sine of a radian number |
| SQRT() | Compute square root |
| TRUNCATE() | Truncate a number to specified decimal places |
The following list shows available vector functions:
| Name | Description |
|---|---|
| F32VEC_DIST() | Return the euclidean distance between vectors |
F32VEC_DIST
f32vec_dist(v1, v2)
The F32VEC_DIST function calculates euclidean distance between FLOAT array v1 and v2.
POW
pow(base, exponent)
The POW function calculates the value of base raised to the power exponent.
SQRT
sqrt(expression)
The SQRT function returns the square root of the given expression.
TRUNCATE
truncate(expression, d)
The TRUNCATE function returns the number truncated to d decimal places.
F32VEC_DIST
f32vec_dist(v1, v2)
The F32VEC_DIST function calculates euclidean distance between FLOAT array v1 and v2.