Multi-dimensional Arrays

Go Up to Defining Arrays

InterBase supports multi-dimensional arrays, arrays with 1 to 16 dimensions. For example, the following statement defines three INTEGER array columns with two, three, and four dimensions respectively:

EXEC SQL
 CREATE TABLE TABLE1
(INT_ARR2 INTEGER[4,5],
INT_ARR3 INTEGER[4,5,6],
INT_ARR4 INTEGER[4,5,6,7]);

In this example, INT_ARR2 allocates storage for 4 rows, 5 elements in width, for a total of 20 integer elements, INT_ARR3 allocates 120 elements, and INT_ARR4 allocates 840 elements.

Important: InterBase stores multi-dimensional arrays in row-major order. Some host languages, such as FORTRAN, expect arrays to be in column-major order. In these cases, care must be taken to translate element ordering correctly between InterBase and the host language.