Home > mailing lists

Reference and arrays - Mailing list pgsql-novice

From	Cima
Subject	Reference and arrays
Date	March 18, 2005 06:38:02
Msg-id	00c701c52b73$f9b55090$f00110ac@doctorado1 Whole thread Raw
Responses	Re: Reference and arrays
List	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!

From: Tom Lane
Date: 18 March 2005, 05:58:24
Subject: Re: Question on simulating Enum Data type

From: uday kumar
Date: 18 March 2005, 09:18:45
Subject: seeking soln.ERROR:;Http status:404 resource not found