Array type proposal

[wiikviz]

Let's think about array behaviour.

let c=[0,2.0,"Str"];
print(c[1]); // 0
let c[0] = 12;
print(c[1]); // 12
print(size(c)) ; // 3
let c=c +[1];
print(c); // [0, 2.0 , "Str", 1]
let c=c +[[2]];
print(c); // [0, 2.0, "Str", 1, [1]]

[LavrVV]

very important question: how to get length?
create array may be this way
let a = array("12", 13);

[wiikviz]

For the length, we have two options:

Do it as Postgre do:
array_length(anyarray, int), see https://www.postgresql.org/docs/12/functions-array.html

or Spark:
let l = size(['b', 'd', 'c', 'a']); // 4 https://spark.apache.org/docs/latest/api/sql/#size
let l = array_size(['b', 'd', 'c', 'a']); // 4 https://spark.apache.org/docs/latest/api/sql/#array_size

[LavrVV]

how it looks toString?

[wiikviz]

https://spark.apache.org/docs/latest/api/sql/#array_join
array_join(array, delimiter[, nullReplacement]) - Concatenates the elements of the given array using the delimiter and an optional string to replace nulls. If no value is set for nullReplacement, any null value is filtered.

https://www.postgresql.org/docs/12/functions-array.html
array_to_string(anyarray, text [, text])
concatenates array elements using supplied delimiter and optional null string
let s = array_to_string(ARRAY[1, 2, 3, NULL, 5], ',', ''); // "1,2,3,,5"

[wiikviz]

What about array_sort ?
https://prestodb.io/docs/current/functions/array.html