Lists & arrays Scalar

array_cross_product()

Compute the cross product of two arrays of size 3. The array elements can not be NULL.

Arguments & returns

2 overloads

Scalar

Overload link	`array`	`array`	Returns
#01	`DOUBLE[3]`	`DOUBLE[3]`	`DOUBLE[3]`
#02	`FLOAT[3]`	`FLOAT[3]`	`FLOAT[3]`

SELECT 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));

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  array_cross_product([1, 2, 3], [1, 2, 3]);