Search Shortcut cmd + k | ctrl + k
Search cmd+k ctrl+k
0.10 (stable)
Array Functions

All LIST functions work with the ARRAY data type. Additionally, several ARRAY-native functions are also supported.

Array-Native Functions

Function Description
array_value(index) Create an ARRAY containing the argument values.
array_cross_product(array1, array2) Compute the cross product of two arrays of size 3. The array elements can not be NULL.
array_cosine_similarity(array1, array2) Compute the cosine similarity between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
array_distance(array1, array2) Compute the distance between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
array_inner_product(array1, array2) Compute the inner product between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
array_dot_product(array1, array2) Alias for array_inner_product(array1, array2).

array_value(index)

Description Create an ARRAY containing the argument values.
Example array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT)
Result [1.0, 2.0, 3.0]

array_cross_product(array1, array2)

Description Compute the cross product of two arrays of size 3. The array elements can not be NULL.
Example array_cross_product(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result [-1.0, 2.0, -1.0]

array_cosine_similarity(array1, array2)

Description Compute the cosine similarity between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
Example array_cosine_similarity(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result 0.9925833

array_distance(array1, array2)

Description Compute the distance between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
Example array_distance(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result 1.7320508

array_inner_product(array1, array2)

Description Compute the inner product between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.
Example array_inner_product(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result 20.0

array_dot_product(array1, array2)

Description Alias for array_inner_product(array1, array2).
Example array_dot_product(l1, l2)
Result 20.0
About this page

Last modified: 2024-05-22