about PostgreSQL...(important)

From: "Frank" <u8924383(at)cc(dot)nkfust(dot)edu(dot)tw>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: about PostgreSQL...(important)
Date: 2001-06-02 12:14:59
Message-ID: 9falko$t0q$1@bbs.nkfu.edu.tw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Constantin Teodorescu 2001-06-04 12:39:05 Re: [INTERFACES] Lots of obsolete docs in pgaccess/lib/help
Previous Message Jeff Johnson 2001-05-31 19:56:18 libpq socket problem on Win32