Subject | Array's |
---|---|
Author | Uwe Oeder |
Post date | 2004-01-22T11:26:33Z |
How would I create a table with an array ?
CREATE TABLE DinnerCalculations
(
DinnerID INTEGER NOT NULL,
DinnerName VARCHAR(100) NOT NULL ,
DinnerType SMALLINT NOT NULL ,
DinnerFoods ARRAY OF INTEGER ,
PRIMARY KEY (DinnerID)
) ;
Like this ?
CREATE TABLE DinnerCalculations
(
DinnerID INTEGER NOT NULL,
DinnerName VARCHAR(100) NOT NULL ,
DinnerType SMALLINT NOT NULL ,
DinnerFoods ARRAY OF INTEGER ,
PRIMARY KEY (DinnerID)
) ;
Like this ?