SQL Reference
Tuple Functions and Operators
tuple functions 120,177,323 true left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type tuple function examples 155,302,135 true left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type tuple operators 113,225,267 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type 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 indexes 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 slice operator examples 136,330,132 true left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type related links docid\ xuk0z8dmxpgmogszpdw6w docid\ nhymyoadealtcppijauc5 docid\ saa2re dvaqcs gtjp3ps docid\ czxgepf3prq9ufwhwbiuy docid\ s0dywbqubbanzcnc4z9fx