#73 PostgreSQL arrays aren't arrays in generated SQL

[Randolf C. Richardson]

PostgreSQL supports arrays. To an an array type of VARCHAR(128) in PostgreSQL, I could enter it as follows in a CREATE TABLE statement:

VARCHAR(128)[]

When I create an alias to the VARCHAR type in Druid, I specify it this way, but the generated SQL code doesn't include the square brackets:

VARCHAR(128)

Although not heavily used, arrays are extremely useful in PostgreSQL where warranted (e.g., a column for passwords that stores old passwords to prevent password re-use by the user {a stored procedure or other additional code would be required to implement that "no re-use" rule}).

Thanks in advance.

[Randolf C. Richardson]

Logged In: YES
user_id=621016
Originator: YES

Change priority to half way between medium and high.