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!

Reply via email to