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