Another question about composite types

From: "Rodrigo Sakai" <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Another question about composite types
Date: 2006-11-13 18:33:40
Message-ID: 000101c70752$3de4b560$4700a8c0@TREEZANTHUS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2006-11-13 18:34:01 Re: drop a check
Previous Message Rodrigo Sakai 2006-11-13 18:27:17 RES: Inserting data in composite types!