From: Michael Ansley <Michael.Ansley@intec-telecom-systems.com>
To: 'Kenn Thompson' <KThompson@adestagroup.com>
Cc: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: RE: Object features of pg
Date: Tue, 3 Oct 2000 15:25:43 +0100
Message-ID: <7F124BC48D56D411812500D0B747251406144D@fileserver002.intecsystems.co.uk> (raw)
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
>> <Michael.Ansley@intec-telecom-systems.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
>>
>>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: Michael.Ansley@intec-telecom-systems.com, KThompson@adestagroup.com
Subject: Re: Object features of pg
In-Reply-To: <7F124BC48D56D411812500D0B747251406144D@fileserver002.intecsystems.co.uk>
References: <7F124BC48D56D411812500D0B747251406144D@fileserver002.intecsystems.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox