Received: from fileserver002.intecsystems.co.uk ([194.200.14.125]) by hub.org (8.10.1/8.10.1) with ESMTP id e93EOcr79838 for ; Tue, 3 Oct 2000 10:24:39 -0400 (EDT) Received: by fileserver002.intecsystems.co.uk with Internet Mail Service (5.5.2650.21) id <4D5C9AY2>; Tue, 3 Oct 2000 15:25:45 +0100 Message-ID: <7F124BC48D56D411812500D0B747251406144D@fileserver002.intecsystems.co.uk> From: Michael Ansley To: "'Kenn Thompson'" Cc: "'pgsql-sql@postgresql.org'" Subject: RE: Object features of pg Date: Tue, 3 Oct 2000 15:25:43 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C02D45.D09BE0A6" X-Archive-Number: 200010/24 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C02D45.D09BE0A6 Content-Type: text/plain; charset="iso-8859-1" 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@adestagroup.com] >> Sent: 03 October 2000 15:15 >> To: Michael.Ansley@intec-telecom-systems.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 >> 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 >> >> ------_=_NextPart_001_01C02D45.D09BE0A6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: [SQL] Object features of pg

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


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

------_=_NextPart_001_01C02D45.D09BE0A6--