Re: 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/