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 and to simplify stored procedures reducing the number of join. Thi idea was born following the discussion concerning EAV. Thank you for contribute. Domenico -----Messaggio originale----- Da: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]Per conto di Joris Dobbelsteen Inviato: domenica 3 febbraio 2008 12:16 A: dfx@xxxxxx; pgsql-general@xxxxxxxxxxxxxx Oggetto: Re: how to add array of objects to a record >-----Original Message----- >From: pgsql-general-owner@xxxxxxxxxxxxxx >[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of dfx >Sent: Sunday, 3 February 2008 10:38 >To: pgsql-general@xxxxxxxxxxxxxx >Subject: how to add array of objects to a record > >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 a table like this: > >create table persons( >id integer, >first_name char(50), >family_name char(50), >phone_numbers phone_number[]) > >and how I have to write the insert and the select queries to >put and get the array of phone numbers? Its an SQL database, do not fall back to paradigms from imperative programming languages (like C, Java, PHP, Perl, ...). Postgres is an implementation of the relational model, which works very nice on sets. It does not have a good concept of pointers and alike (they can be represented, but inefficiently). Transform you type into a table and add an "id" attribute that references the persons table (using a foreign key). At this point you can use regular SQL statements. - Joris ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
