Re: R: [GENERAL] how to add array of objects to a record

2008-02-03 Thread David Fetter
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

R: [GENERAL] how to add array of objects to a record

2008-02-03 Thread dfx
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

Re: [GENERAL] how to add array of objects to a record

2008-02-03 Thread Joris Dobbelsteen
>-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

[GENERAL] how to add array of objects to a record

2008-02-03 Thread dfx
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