pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Ansley <Michael.Ansley@intec-telecom-systems.com>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: RE: Object features of pg
Date: Tue, 3 Oct 2000 15:21:38 +0100
Message-ID: <7F124BC48D56D411812500D0B747251406144C@fileserver002.intecsystems.co.uk> (raw)

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: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
<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
<http://www.retep.org.uk;  
>>   PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
<http://www.retep.org.uk/postgres/;  
>>   Java PDF Generator http://www.retep.org.uk/pdf/
<http://www.retep.org.uk/pdf/;  
>>   
>>   

view thread (8+ messages)  latest in thread

Message-ID: <7F124BC48D56D411812500D0B747251406144C@fileserver002.intecsystems.co.uk>
Permalink:  ../7F124BC48D56D411812500D0B747251406144C@fileserver002.intecsystems.co.uk/
Also on:    postgresql.org/message-id/7F124BC48D56D411812500D0B747251406144C@fileserver002.intecsystems.co.uk

 · 

reply

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
  Subject: Re: Object features of pg
  In-Reply-To: <7F124BC48D56D411812500D0B747251406144C@fileserver002.intecsystems.co.uk>
  References: <7F124BC48D56D411812500D0B747251406144C@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