RE: Object features of pg
От | Michael Ansley |
---|---|
Тема | RE: Object features of pg |
Дата | |
Msg-id | 7F124BC48D56D411812500D0B747251406144C@fileserver002.intecsystems.co.uk обсуждение исходный текст |
Ответ на | Object features of pg (Michael Ansley <Michael.Ansley@intec-telecom-systems.com>) |
Список | pgsql-sql |
-----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 pgHi, 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 expressionSo 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/
>>
>>
В списке pgsql-sql по дате отправления: