RE: Object features of pg

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 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?

Hmmm, try:

update client set address = 18935::oid where name = 'Michael';

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/