Operators Operator

||

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

Operands & returns

Operator

Overload link	`string`	`string`	Returns
#01	`ANY`	`ANY`	`ANY`

SELECT 'Duck' || 'DB';

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

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.