Postgres object orientation
От | Guillaume Rousse |
---|---|
Тема | Postgres object orientation |
Дата | |
Msg-id | 00010619331801.04353@agathe обсуждение исходный текст |
Ответы |
Re: [GENERAL] Postgres object orientation
|
Список | 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 R�union 15 avenue Ren� Cassin, BP 7151 97715 Saint Denis, messagerie cedex 9 Tel:0262938287 Fax:0262938260 ICQ:10756815 Mail:Guillaume.Rousse@univ-reunion.fr BRIDGEKEEPER: What... is the air-speed velocity of an unladen swallow? ARTHUR: What do you mean? An African or European swallow?
В списке pgsql-general по дате отправления: