The same 3 types that share indexing operator (str,
bytes, and arrays) also share the ability to concatenate
two values. The ++ operator is used for that purpose:
Input
SELECT'Hello'++' world';
Run
Output
Press the 'Run' button to evaluate the input
Input
SELECTb'byte'++b'-string';
Run
Output
Press the 'Run' button to evaluate the input
Input
SELECT [1, 1] ++ [2, 3];
Run
Output
Press the 'Run' button to evaluate the input
Note that tuples don't have any concatenation operator.