RE: Object features of pg

No. I want the address attribute of the client class to be of type address,
which is defined by the address table. Perhaps I should have named things a
little more clearly ;-)

>> -----Original Message-----
>> From: Kenn Thompson [mailto:KThompson(at)adestagroup(dot)com]
>> Sent: 03 October 2000 15:15
>> To: Michael(dot)Ansley(at)intec-telecom-systems(dot)com
>> Subject: Re: [SQL] Object features of pg
>>
>>
>> Shouldn't that be
>> create table address (address varchar(50), postcode varchar(9));
>> create table client(id integer, name varchar(30), address
>> varchar(50);
>> ?
>>
>> >>> Michael Ansley
>> <Michael(dot)Ansley(at)intec-telecom-systems(dot)com> 10/03/00 08:14AM >>>
>> I've done the following:
>>
>> create table address (address varchar(50), postcode varchar(9));
>> create table client(id integer, name varchar(30), address address);
>>
>> Now, how the hell do I get information into the address
>> field of client?
>> There appears to be very little in the manual dealing with
>> PGs object
>> features. Any pointers to places in the manual, or direct
>> instructions
>> would be gratefully accepted.
>>
>> Cheers...
>>
>> MikeA
>>
>>