> CREATE TYPE t_salary AS (Value numeric(10,2), Validity date);
> CREATE TABLE employee (id int, name varchar(30), salary t_salary[]);
>
> That is, I need an array of composite type and searching on google I found
> that is impossible to do it! Is it really impossible? Anyone have do it ?
Why not use a conventional table to hold this information that references your employee table?
Regards,
Richard Broersma Jr.