about PostgreSQL...(important)

Frank <u8924383@cc.nkfust.edu.tw>

From: "Frank" <u8924383@cc.nkfust.edu.tw>
To: pgsql-general@postgresql.org
Date: 2001-06-02T12:13:57Z
Lists: pgsql-general
Hi to all:
    I have a question.
    PostgreSQL is Object-Relational DBMS . Can I progam Object-Oriented
Language for PostgreSQL?

Example:
    I create two tables:
                create table Address(
                              street char(20),
                              city char(20),
                              province char(20)
                 );

                 create table students(
                                 no int4,
                                 name char(8),
                                 address  Address,
                )
               insert into Address values ('ZHONG-SHAN','TAIPEI','TAIWAN');

    I find the Address record's oid:
            =>  select oid from Address where province='TAIWAN';

                               oid
                             --------
                              28672
    Then, I insert a record to students table:
            =>  insert into students values (8852,'John',28672::Address);

   Finally, I select the  record about the student's province depend on oid:
            =>select no,name,address.province from students;

   BUT PostgreSQL's message is error,why?

Thank you.....
                 Frank