[DERBY-4335] Support the array datatype as used in Postgres

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: SQL
• Labels: derby_triage10_10
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Paul taylor
• Created: 04/Aug/09 12:29
• Updated: 30/Sep/12 01:23

Description

Note I would have liked to raise this issue as a New Issue rather than an improvement but that option does not seem to exist.

This functionality would be useful for many applications, but for me its most important use would be to allow Derby to mimic Postgres well enough for embedded derby to be used as the embedded db for junit testing application. Using an embedded db like derby holds many advantages over a full db for unit testing but because the postgres supports arrays and the application uses this feature and derby does not I cannot use it for junittesting.