Postgres object orientation

From: Guillaume Rousse <Guillaume(dot)Rousse(at)univ-reunion(dot)fr>
To: pgsql-general(at)hub(dot)org
Subject: Postgres object orientation
Date: 2000-01-06 14:55:08
Message-ID: 00010619331801.04353@agathe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.
Some questions on object-orientation of Postgress:
Firstly, is there any possibility of using directly a class name as a type for
another class attribute, without using an explicit key linking, as in a full
ODBMS ?
For example :
CREATE writers(name TEXT)
CREATE books(authors writers[])
Secondly, how does inheritance affect auto-generated primary keys ? Is it
unique among all inherited classes ?
For example :
CREATE cities(id SERIAL, name TEXT)
CREATE capitol INHERIT cities(country TEXT)
Can i be sure that there won't be two identical id in thoses two classes, and
that a SELECT name FROM cities* WHERE id=x won't return two names ?
Thanks for your help.
Subsidiary question : why is mySQL excluded from RDBMS comparison on postgress
www site ?

--
Guillaume Rousse
*******************************************
Iremia - Universit de la Runion
15 avenue Ren Cassin, BP 7151
97715 Saint Denis, messagerie cedex 9
Tel:0262938287 Fax:0262938260 ICQ:10756815
Mail:Guillaume(dot)Rousse(at)univ-reunion(dot)fr

BRIDGEKEEPER: What... is the air-speed velocity of an unladen swallow?
ARTHUR: What do you mean? An African or European swallow?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karl DeBisschop 2000-01-06 15:35:13 Re: [BUGS] problem creating index in 6,5,3
Previous Message The Hermit Hacker 2000-01-06 13:41:15 Re: [GENERAL] Benchmarks