Implicit cast between element types

When an implicit cast exists in the database to convert between different element types of two collections, you are not required to use an explicit cast to insert or update elements from one collection into another collection. The following INSERT statement retrieves elements from the set_tab2 table and inserts the elements into the set_tab3 table. Although the collection column from set_tab2 has an INT element type and the collection column from set_tab3 has a FLOAT element type, a built-in cast implicitly handles the conversion between INT and FLOAT values. An explicit cast is unnecessary in this case.

INSERT INTO set_tab3 SELECT col2 FROM set_tab2