Skip to content
Blog

List Functions

The following table shows the operators that can be used with lists.

OperatorDescriptionExampleResult
+concatenates two listsRETURN [1,2,3] + [4,5] AS mylist[1,2,3,4,5]
[start:stop]access specific elements in a listWITH [1,2,3,4,5] AS mylist RETURN mylist[1:3][1,2]
INoperator for the list_contains function1 IN [1,2,3]true