RE: Object features of pg

-----Original Message-----
From: Michael Ansley [mailto:Michael.Ansley@intec-telecom-systems.com]
Sent: 03 October 2000 14:44
To: 'Peter Mount'
Cc: 'pgsql-sql@postgresql.org'
Subject: RE: [SQL] Object features of pg

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:peter@retep.org.uk]
>>   Sent: 03 October 2000 14:32
>>   To: Michael Ansley
>>   Cc: 'pgsql-sql@postgresql.org'
>>   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 peter@retep.org.uk http://www.retep.org.uk
>>   PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
>>   Java PDF Generator http://www.retep.org.uk/pdf/
>>  
>>