Re: Another question about composite types - Mailing list pgsql-sql

From Richard Broersma Jr
Subject Re: Another question about composite types
Date
Msg-id 277719.72609.qm@web31811.mail.mud.yahoo.com
Whole thread Raw
In response to Another question about composite types  ("Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>)
Responses RES: Another question about composite types
List pgsql-sql
>   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.


pgsql-sql by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: drop a check
Next
From: "Rodrigo Sakai"
Date:
Subject: RES: Another question about composite types