Tuple Functions and Operators

tuple functions function syntax purpose constructor tuple<\<type1,type2, …, typen>>(e1, e2, …, en) construct a tuple given elements null is also supported as an element implicit constructor tuple(e1, e2, …, en) construct a tuple with the specified elements types of the tuple are inferred from the inner elements convert tuple to string char(tuple) converts a tuple to its string representation convert string to tuple string to tuple(str, format) converts the string representation of a tuple (e g , 'tuple<\<int,bigint,char>>(1,2,null)') into a tuple tuple casting cast to tuple(tuple, format) converts a tuple into another tuple of a different type (e g , cast to tuple(tuple<\<int,int>>(1,2), 'tuple(bigint,double)')) tuple function examples function sql statement result type constructor tuple<\<int,bigint>>(1,2) tuple holding int(1) and bigint(2) type constructor for array of tuples tuple<\<int,bigint>>\[]\(tuple<\<int,bigint>>(1,2), tuple<\<int,bigint>>(3,4)) array holding 2 tuples \[(1,2), (1,2)] char(\<tuple value>) char(tuple<\<int,bigint>>(1,2)) 'tuple<\<int,bigint>>(1,2)' string to array string to array('tuple<\<int,bigint>>\[tuple<\<int,bigint>>(1,2)]','array(tuple(int,bigint))') tuple<\<int,bigint>>\[tuple<\<int,bigint>>(1,2)] tuple operators operator syntax description access operator tuple\[element index] returns the element stored in the specified index position the index starts at 1 access out of bounds returns a null slice operator tuple\[left index\ right index] returns the subtuple ranging from left index to right index inclusive the index starts at 1 about the tuple slice operator each index starts at 1 if the tuple is null or either index value is null, the result of the slicing is null if you omit the left index, it is equivalent to using 1 if you omit the right index, it is equivalent to len(tuple) if you omit both, it returns the full tuple tuple<\<int,int,int>>(1, 2, 3)\[ ] is equivalent to tuple<\<int,int,int>>(1, 2, 3) values below zero for the left index convert to 1 , and values beyond the tuple length for the right index convert to len(tuple) tupleval\[ 1 4] is equivalent to tupleval\[1 4] , and tuple<\<int,int,int>>(1, 2, 3)\[1 6] is equivalent to tuple<\<int,int,int>>(1, 2, 3)\[1 3] ranges completely out of tuple bounds throw an invalid argument error, e g , tuple<\<int,int>>(1,2)\[4 5] sequential slices slice each dimension of tuples tuple<\<tuple<\<int,int,int>>,tuple<\<int,int,int>>>>(tuple<\<int,int,int>>(1, 2, 3), tuple<\<int,int,int>>(4, 5, 6))\[1 1]\[2 3] = tuple<\<tuple<\<int,int>>>>(tuple<\<int,int>>(2, 3)) more than n sequential slices of an n dimensional tuple, for example, three sequential slices on a two dimensional tuple throw an error tuple<\<int>>(1)\[ ]\[ ] you cannot combine slicing with the access operator if you attempt such a combination, any access operator \[n] converts to \[ n] tupleval\[4]\[1 6] = tupleval\[ 4]\[1 6] slicing with non constant indixes throws an error slicing a tuple of arrays such as tuple<\<int\[],double\[]>>(int\[1,2,3],double\[4,5,6])\[1 1]\[2 3] slices \[1 1] on the tuple and \[2 3] on the resulting inner arrays, resulting in tuple<\<int\[]>>(int\[2,3]) slicing a tuple with a mix of containers and primitives such as tuple<\<int,int\[]>>(1,int\[1,2,3]) throws an error if, at any given depth, the slice is not valid for one or more elements slicing the tuple with \[ ]\[2 3] fails because you cannot slice an integer, and the resultant tuple from \[ ] includes an integer however, slicing with \[2 2]\[2 3] returns tuple<\<int\[]>>(int\[2,3]) because the tuple resulting from the \[2 2] slice contains only elements that the next slice range can sliced operator examples operator sql predicate result access operator tuple<\<char,bigint>>('sql',2)\[1] 'sql' access operator tuple<\<char,bigint>>('sql',2)\[2] null slice operator tuple<\<char,bigint,bigint>>('sql',1,2)\[1 2] tuple<\<char,bigint>>('sql',1) related links array functions and operators docid\ ymza gmw5298nhgmbsuyn matrix functions and operators docid\ uplpscv6tgx3s4qlmv9c0 math functions and operators docid\ jbcpq ilyezmmxoz8csfr data types docid\ g9 6amoszrxd9exdwggcz query ocient docid\ pj83zadmfz4dqseq5on7n