Lists & arrays Scalar

list_intersect()

Returns a list containing the distinct elements that are present in both list1 and list2.

Arguments & returns

Scalar

Overload link	`list1`	`list2`	Returns
#01	`T[]`	`T[]`	`T[]`

SELECT list_intersect([1, 2, 3], [2, 3, 4]);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.