On Tue, 3 Oct 2000, Michael Ansley wrote:
> 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 s
hat 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
> &
Title: RE: [SQL] Object features of pg
Hi, Kenn,
>> It seems that if you want to define a type address that
>> you will need more than a reference in another table. I
>> see what you're trying to do, but don't understand the
>> advantage of havi
Title: RE: [SQL] Object features of pg
No. I want the address attribute of the client class to be of type address, which is defined by the address table. Perhaps I should have named things a little more clearly ;-)
>> -Original Message-
>> From: Kenn Thompson [m
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 fun
Title: 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 189
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 ap
