Reference and arrays

From: "Cima" <ruel(dot)cima(at)facinf(dot)uho(dot)edu(dot)cu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Reference and arrays
Date: 2005-03-18 04:35:43
Message-ID: 00c701c52b73$f9b55090$f00110ac@doctorado1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi,
im using postgresql 8.0.1 and i want to be able to do the following:

create table t1 (name varchar(10), age int2);

create table t2 (position varchar(20), worker t1[]);

meaning i want to be able to declare worker as an array of t1. if that is possible how do i insert into values t2.
after that can i make a reference to another table using the array. something like this:

create table t3 (month varchar(20), bday reference t1[]);

or something as close to this as possible.

thanx a lot!


Responses

Browse pgsql-novice by date

  From Date Subject
Next Message uday kumar 2005-03-18 06:18:36 seeking soln.ERROR:;Http status:404 resource not found
Previous Message Tom Lane 2005-03-18 02:58:15 Re: Question on simulating Enum Data type