Hi, Peter,
I suspected as much of the querying, but I can't even get data into the tables. I tried this:
insert into client values ('Michael');
insert into address values ('11 Windsor Close, 'RH16 4QR');
INSERT 18935 1
update client set address = 18935 where name = 'Michael';
ERROR: Attribute 'address' is of type 'address' but expression is of type 'int4
'
You will need to rewrite or cast the expression
So that didn't work, and I tried casting the oid, but that didn't seem to work either. Any ideas?
Cheers...
>> -----Original Message-----
>> From: Peter Mount [mailto:[EMAIL PROTECTED]]
>> Sent: 03 October 2000 14:32
>> To: Michael Ansley
>> Cc: '[EMAIL PROTECTED]'
>> Subject: Re: [SQL] Object features of pg
>>
>>
>> On Tue, 3 Oct 2000, Michael Ansley wrote:
>>
>> > 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.
>>
>> Something like:
>>
>> select id,name,a.address,postcode
>> from client c, address a
>> where c.address=a.oid;
>>
>> Probably neater ways of doing it...
>>
>> Peter
>>
>> --
>> Peter T Mount [EMAIL PROTECTED] http://www.retep.org.uk
>> PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
>> Java PDF Generator http://www.retep.org.uk/pdf/
>>
>>
