db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hong Ji" <hongco...@gmail.com>
Subject ARRAY
Date Fri, 11 Aug 2006 07:46:13 GMT
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

Mime
View raw message