From: imad <immaad@gmail.com>
To: rodrigo.sakai@zanthus.com.br
Cc: Richard Broersma Jr <rabroersma@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Another question about composite types
Date: Tue, 14 Nov 2006 00:04:12 +0500
Message-ID: <1f30b80c0611131104y3e257fddg6286dd548507b279@mail.gmail.com> (raw)
In-Reply-To: <000c01c70757$dbe70c90$4700a8c0@TREEZANTHUS>
References: <277719.72609.qm@web31811.mail.mud.yahoo.com>
<000c01c70757$dbe70c90$4700a8c0@TREEZANTHUS>
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.sakai@zanthus.com.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@yahoo.com]
> Enviada em: segunda-feira, 13 de novembro de 2006 14:46
> Para: rodrigo.sakai@zanthus.com.br; pgsql-sql@postgresql.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: immaad@gmail.com, rodrigo.sakai@zanthus.com.br, rabroersma@yahoo.com
Subject: Re: Another question about composite types
In-Reply-To: <1f30b80c0611131104y3e257fddg6286dd548507b279@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox