RE: [SQL] Object features of pg

[Michael Ansley]

Title: RE: [SQL] Object features of pg

Is anybody using the object features of PG?  We're busy evaluating databases for some prototyping projects, and relational, object and OR databases are all in the mix.  What I'm trying to do is to see how closely PG can match the object functionality of an object database.  I'm dead against going with an object database because I feel that the functionality that they provide is quite limiting.  In fact, you can't really do anything with an object unless you instantiate it, which is fine in some applications, but when you trying to process thousands of rows per second, it rather limiting.  Any views and opinions of people who have done (or tried to do) this would be most welcome.

 

Cheers...

 

 

MikeA

 

PS. Is anybody else having problems with the pgsql-general list, because I've sent about three messages to it, and it hasn't appeared.

 

 

-----Original Message-----
From: Michael Ansley [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2000 14:44
To: 'Peter Mount'
Cc: '[EMAIL PROTECTED]'
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:[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/
>>  
>>