From: | imad <immaad(at)gmail(dot)com> |
---|---|
To: | rodrigo(dot)sakai(at)zanthus(dot)com(dot)br |
Cc: | "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Another question about composite types |
Date: | 2006-11-13 19:04:12 |
Message-ID: | 1f30b80c0611131104y3e257fddg6286dd548507b279@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
There is always an _typname created for arrays like we have _int4 for
_int4, _varchar for varchar and _timestamp for timestamp etc.
May be you have to write some _typname for your type to use it in
arrays. We always use array_in and array_out for _typenames BTW.
This may be helpful to you.
--Imad
www.EnterpriseDB.com
On 11/14/06, Rodrigo Sakai <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br> wrote:
> I know that if I create a table salary that references my employee table
> works! But I'm trying to work with the composite type concept!
>
> Thinking in Object-Oriented Programming (OOP) I have a class employee that
> is composed by the class salary among other things! Like:
>
> Class salary {
> private float value;
> private date validity;
> }
>
> Class employee {
> private int ID;
> private String name;
> private salary[] sal;
> }
>
> So I'd like to map these classes to PostgreSQL. I think nested tables are
> one of the advantages of object-relational databases. And it works if I
> think in just one salary for each employee. But I want to keep all salary
> history for each employee. Is there any way?
>
> -----Mensagem original-----
> De: Richard Broersma Jr [mailto:rabroersma(at)yahoo(dot)com]
> Enviada em: segunda-feira, 13 de novembro de 2006 14:46
> Para: rodrigo(dot)sakai(at)zanthus(dot)com(dot)br; pgsql-sql(at)postgresql(dot)org
> Assunto: Re: [SQL] Another question about composite types
>
> > 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2006-11-13 19:06:36 | Re: drop a check |
Previous Message | Volkan YAZICI | 2006-11-13 19:01:53 | Re: drop a check |