Re: Another question about composite types

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
>