Hi, I need to create a table like:
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 ?
Thanks!