Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

2.6.3 Inserting rows into a table with repetition columns

When inserting rows into a table that has repetition columns, specify the insertion values for the repetition columns using the following format: ARRAY[element-value[,element-value]...]. Figure 2-22 shows an example of inserting rows into a table that has repetition columns. This example inserts a row into a staff table.

Figure 2-22 Example of inserting a row into a table with repetition columns

[Figure]