db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: ARRAY
Date Fri, 11 Aug 2006 14:57:24 GMT
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.


Mime
View raw message