| From: | "Frank" <u8924383(at)cc(dot)nkfust(dot)edu(dot)tw> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | about PostgreSQL...(important) |
| Date: | 2001-06-02 12:13:57 |
| Message-ID: | 9faliq$t0d$1@bbs.nkfu.edu.tw |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | will trillich | 2001-06-02 12:35:45 | Re: Am I headed in the right direction? (long) |
| Previous Message | will trillich | 2001-06-02 12:11:29 | Re: Re: Incrementing a date type. |