Object syntax

From: Michael Ansley <Michael(dot)Ansley(at)intec-telecom-systems(dot)com>
To: sqllist <pgsql-sql(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Object syntax
Date: 2000-10-05 13:19:40
Message-ID: 7F124BC48D56D411812500D0B7472514061460@fileserver002.intecsystems.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Given the following table definitions, and data inserts:

dev=# create address (addr varchar(50), postcode varchar(9));
dev=# create client (name varchar(30), addr address);
dev=# insert into client values ('Michael');
dev=# insert into address values ('11 Windsor Close', 'RH16 4QR');
INSERT 18935 1
dev=# update client set addr = 18935::address;

dev=# explain select client.addr.postcode from client;
NOTICE: QUERY PLAN:
Seq Scan on client (cost=0.00..1.01 rows=1 width=4)
EXPLAIN
dev=# select client.addr.postcode from client;
ERROR: init_fcache: Cache lookup failed for procedure 18935

What's happening here? Bug, or am I doing something wrong?

Cheers...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jono 2000-10-05 13:23:06 Oracle to POSTGRESQL
Previous Message Jan Wieck 2000-10-05 12:38:46 Re: VIEW problem

Browse pgsql-sql by date

  From Date Subject
Next Message Didier Boudigue 2000-10-05 13:47:41 JDBC and BLOB in Postgres
Previous Message Craig May 2000-10-05 06:07:56 createuser