On 8/11/06, Stanley Bradbury <[EMAIL PROTECTED]> wrote:
Hong Ji wrote:
> Hello,
>
> How to create a table with a colume is of type ARRAY?
> The following SQL statement fails at "ARRAY."
>
> "create table APP.Rooms (" +
> "ID INTEGER NOT NULL PRIMARY KEY
> GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)," +
> "SYMBOL VARCHAR(30), " +
> "TYPE VARCHAR(30), " +
> "TICKET_IDS ARRAY" +
> ")";
>
> So how to define the TICKET_IDS field as array of integers in Derby?
>
> Thanks.
>
> Hong
>
>
To set this up in Derby you could list the array values in a child table
the load the array programatically when reading the records.
