Another question about composite types - Mailing list pgsql-sql

From Rodrigo Sakai
Subject Another question about composite types
Date
Msg-id 000101c70752$3de4b560$4700a8c0@TREEZANTHUS
Whole thread Raw
Responses Re: Another question about composite types
List pgsql-sql

  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!

pgsql-sql by date:

Previous
From: ivan marchesini
Date:
Subject: drop a check
Next
From: Richard Broersma Jr
Date:
Subject: Re: RES: Inserting data in composite types!