pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Another question about composite types
3+ messages / 3 participants
[nested] [flat]
* Re: Another question about composite types
@ 2006-11-13 17:46 Richard Broersma Jr <rabroersma@yahoo.com>
parent: Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>
0 siblings, 1 reply; 3+ messages in thread
From: Richard Broersma Jr @ 2006-11-13 17:46 UTC (permalink / raw)
To: rodrigo.sakai@zanthus.com.br; 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Another question about composite types
@ 2006-11-13 18:33 Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>
0 siblings, 1 reply; 3+ messages in thread
From: Rodrigo Sakai @ 2006-11-13 18:33 UTC (permalink / raw)
To: 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!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Another question about composite types
@ 2006-11-13 19:04 imad <immaad@gmail.com>
parent: Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: imad @ 2006-11-13 19:04 UTC (permalink / raw)
To: rodrigo.sakai@zanthus.com.br; +Cc: Richard Broersma Jr <rabroersma@yahoo.com>; 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.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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-11-13 19:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-13 18:33 Another question about composite types Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>
2006-11-13 17:46 ` Richard Broersma Jr <rabroersma@yahoo.com>
2006-11-13 19:04 ` imad <immaad@gmail.com>
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