Operators Operator

||

Concatenates two strings, lists, or blobs. Any NULL input results in NULL. See also concat(arg1, arg2, ...) and list_concat(list1, list2, ...).

Operands & returns

`arg1 || arg2`

Operator

Overload link	`arg1`	`arg2`	Returns
#01	`ANY`	`ANY`	`ANY`

Example

2 more ↓

SELECT 'Duck' || 'DB';

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

More examples

SELECT [1, 2, 3] || [4, 5, 6];

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT '\xAA'::BLOB || '\xBB'::BLOB;

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3