db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hong Ji" <hongco...@gmail.com>
Subject Re: ARRAY
Date Sat, 12 Aug 2006 05:03:21 GMT
Thanks for the wiki link and the child table suggestion.

On 8/11/06, Stanley Bradbury <Stan.Bradbury@gmail.com> 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.
>
>

Mime
View raw message