<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>