Skip to main content

CONCAT

The CONCAT function is used to concatenate two or more list values together.

Syntax​

CONCAT(list_value1, list_value2, ...)

Parameters:

  • list_value1, list_value2, ...: List values that will be concatenated.

Examples​

Consider the following table ListTypeConcat:

CREATE TABLE ListTypeConcat (
    id INTEGER,
    items LIST,
    items2 LIST
);

With the following data:

INSERT INTO ListTypeConcat VALUES
    (1, '[1, 2, 3]', '["one", "two", "three"]');

Example 1: CONCAT two lists​

SELECT CONCAT(items, items2) AS myconcat FROM ListTypeConcat;

Result:

myconcat
[1, 2, 3, "one", "two", "three"]