Creating Arrays
From InterBase
Go Up to Using Arrays
Arrays are defined with the CREATE DOMAIN
or CREATE TABLE
statements. Defining an array column is just like defining any other column, except that you must also specify the array dimensions.
Array indexes range from –231 to +231–1.
The following statement defines a regular character column and a single-dimension, character array column containing four elements:
EXEC SQL CREATE TABLE TABLE1 ( NAME CHAR(10), CHAR_ARR CHAR(10)[4] );
Array dimensions are always enclosed in square brackets following a data type specification of a column.
For a complete discussion of CREATE TABLE
and array syntax, see Language Reference Guide.