April 2017
Beginner to intermediate
360 pages
9h 35m
English
We have seen that we can use the frozen collections nested within other collections. Similarly, we can also use tuples nested within a tuple (no need to be frozen).
For example, column_name tuple <int, tuple <int, text>>.
We can also use tuples and UDTs within other generic collections such as set, list, and map albeit they have to be frozen. Suppose that we are trying to store the education history of users. We can do so by creating a set of the user-defined type "education_information". We can create the set like this:
ALTER TABLE "users" ADD "education_history" set<frozen<"education_information">>;
Let's try adding some education history for the user 'alice':
UPDATE "users" SET "education_history" = {{ "school_name": ...Read now
Unlock full access