how to add array of objects to a record - Mailing list pgsql-general

From dfx
Subject how to add array of objects to a record
Date
Msg-id 002c01c86648$849a1cb0$f400a8c0@SEMPRON
Whole thread Raw
List pgsql-general
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?

thank you

Domenico


pgsql-general by date:

Previous
From: Jean-Paul Argudo
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL Certification
Next
From: "Joris Dobbelsteen"
Date:
Subject: Re: how to add array of objects to a record