Scalars

Closely related to scalars are arrays and tuples. These types are ordered collections of scalar values that are treated as a single value themselves.

Arrays are homogeneous collections, meaning that all of the elements have to be of the same type:

Input

SELECT [1, 1, 2, 3, 5];

SELECT [1, 1, 2, 3, 5];

Array elements can be accessed by giving an index (starting with 0) enclosed in [...]:

Input

# access index 4 of the array [1, 1, 2, 3, 5]
SELECT [1, 1, 2, 3, 5] [4];

# access index 4 of the array [1, 1, 2, 3, 5]
SELECT [1, 1, 2, 3, 5] [4];

Tuples are heterogeneous collections, meaning that tuple elements can be of any type (that includes arrays and tuples as well):

Input

SELECT (1, "Hello", true);

SELECT (1, "Hello", true);

Tuples elements can be accessed by specifying an index after a .:

Input

SELECT (1, "Hello", true).0;

SELECT (1, "Hello", true).0;

Tuples can also give names to their elements. In that case the tuple elements can be accessed by either name or index:

Input

SELECT (val := 1, text := "Hello", flag := true);

SELECT (val := 1, text := "Hello", flag := true);

Input

# access by name
SELECT (val := 1, text := "Hello", flag := true).text;

# access by name
SELECT (val := 1, text := "Hello", flag := true).text;

Input

# access by index
SELECT (val := 1, text := "Hello", flag := true).1;

# access by index
SELECT (val := 1, text := "Hello", flag := true).1;