Database Reference
In-Depth Information
Working with tuples
We saw that collections are a versatile tool for working with multiple values in a single
column. One limitation of collections, however, is that all elements of a collection must be
of the same type. If we want to store values of different types in the same collection, we
can instead turn to
tuples
.
Unlike collections, which can store an arbitrary number of elements, a tuple column stores
a fixed number of elements, each of which has a predefined type. So, while we gain the
flexibility to store elements of different types in the same column, we give up flexibility in
the number of elements stored.
