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?
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 |