RE: Object features of pg

<p><font size="2">No.  I want the address attribute of the client class to be of type address, which is defined by the
addresstable.  Perhaps I should have named things a little more clearly ;-)</font><br /><p><font size="2">>>  
-----OriginalMessage-----</font><br /><font size="2">>>   From: Kenn Thompson [<a
href="mailto:KThompson@adestagroup.com">mailto:KThompson@adestagroup.com</a>]</font><br/><font size="2">>>  
Sent:03 October 2000 15:15</font><br /><font size="2">>>   To: Michael.Ansley@intec-telecom-systems.com</font><br
/><fontsize="2">>>   Subject: Re: [SQL] Object features of pg</font><br /><font size="2">>>   </font><br
/><fontsize="2">>>   </font><br /><font size="2">>>   Shouldn't that be </font><br /><font
size="2">>>  create table address (address varchar(50), postcode varchar(9));</font><br /><font
size="2">>>  create table client(id integer, name varchar(30), address </font><br /><font size="2">>>  
varchar(50);</font><br/><font size="2">>>   ?</font><br /><font size="2">>>   </font><br /><font
size="2">>>  >>> Michael Ansley </font><br /><font size="2">>>  
<Michael.Ansley@intec-telecom-systems.com>10/03/00 08:14AM >>></font><br /><font size="2">>>  
I'vedone the following:</font><br /><font size="2">>>   </font><br /><font size="2">>>   create table
address(address varchar(50), postcode varchar(9));</font><br /><font size="2">>>   create table client(id
integer,name varchar(30), address address);</font><br /><font size="2">>>   </font><br /><font
size="2">>>  Now, how the hell do I get information into the address </font><br /><font size="2">>>   field
ofclient?</font><br /><font size="2">>>   There appears to be very little in the manual dealing with </font><br
/><fontsize="2">>>   PGs object</font><br /><font size="2">>>   features.  Any pointers to places in the
manual,or direct </font><br /><font size="2">>>   instructions</font><br /><font size="2">>>   would be
gratefullyaccepted.</font><br /><font size="2">>>   </font><br /><font size="2">>>   Cheers...</font><br
/><fontsize="2">>>   </font><br /><font size="2">>>   MikeA</font><br /><font size="2">>>  
</font><br/><font size="2">>>   </font>