Uhm ... well that's not 100% true. You can support arrays by putting them in as a blob. But I don't think that's what the user meant.
Depending on how extensible Derby is, you could in theory create a data type but I believe that's beyond Derby's capabilities. IDS allows for this type of extensibility, but the real question is why? You have a relational database, why would you want to store your data in an array which has limited access types and depending on the size... not the best for retrieving information? > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Tuesday, August 04, 2009 7:12 AM > To: Derby Discussion > Subject: Re: Does derby support arrays > > Paul Taylor wrote: > > Does Postgres supports array datatype ? > > > > i.e > > CREATE TABLE album > > ( > > attributes integer[] DEFAULT '{0}' > > } > > > > does derby support this it doesn't appear to, will it support it ? > > Hello Paul, > > No, Derby doesn't support the array data type [1]. > I'm not aware of any plans to support it. > You're welcome to add a RFE to track any efforts of implementing support > for it: > https://issues.apache.org/jira/browse/DERBY > > > Regards, > -- > Kristian > > [1] http://wiki.apache.org/db-derby/JDBCSupport - this is getting a bit > outdated. For instance, I believe all Clob methods are now supported in > both drivers. I'll see if I can update the page. Others are free to > contribute as well of course :) > > > For me I want to use derby as my database in embedded mode for unit > > testing my code, but I'm now stuck because the postgres db Im > > replicating uses an array datatype. > > > > Paul
