Dear,

On Thu, 22 Jan 2004 13:26:33 +0200,
Uwe Oeder wrote :

> 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)
>
> ) ;

No, like this :

DinnerFoods INTEGER [10],

But keep your eyes on Nando and Lester comments.
The case you expose has probably a much better solution with a detail
table.

--
Best Regards,
Olivier Mascia