On Sun, Feb 03, 2008 at 10:00:04PM +0100, dfx wrote:
> Yes, this is the "normal" way, but I was tempted to investigate the
> possibility to use array (of string) or composite types to avoid to
> increase the number of tables
That is an extremely bad thing to "optimize" for. Add tables as
needed f
AV.
Thank you for contribute.
Domenico
-Messaggio originale-
Da: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] conto di Joris
Dobbelsteen
Inviato: domenica 3 febbraio 2008 12:16
A: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Oggetto: Re: [GENERAL] how to add array of objects t
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of dfx
>Sent: Sunday, 3 February 2008 10:38
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] how to add array of objects to a record
>
>Hi list,
>
>Can I add an array
Hi list,
Can I add an array of object to a record?
For example if I have a class (or type) phone_number:
create type phone_number as(
name char(20),
caption char(50),
ph_num char(25));
and I would like associate several (unknown number, a priori) phone numbers
to a record "persons"
can I create