From: | Guillaume Rousse <Guillaume(dot)Rousse(at)univ-reunion(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Just to be sure... |
Date: | 2000-02-27 23:03:59 |
Message-ID: | 00022803181600.19333@agathe |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've some question about PostgreSQL object-orientations, as explained in the
JDBC prgramming manual (extended Postrgres API).
You can use table A as a type for a field in table B like this : create table
A (foo text); create table B (fee B);
This ensure 1-to-n relation between A and B like classical B foreign
key linked to A primary Key, with relational constraint morevoer : you can't
delete any tuple in A still linked to in B. Am i right to this point ?
Ok, here's what seems to be impossible :
- Declare a field as an array of another table, so as to have a n-to-n
relationship. I've tried create B (fee B[]), it doesn't function.
- Declare a recursive declaration. I tried create table A(foo A), it
doesn't function either.
--
Guillaume Rousse
Iremia - Universit de la Runion
15 avenue Ren Cassin, BP 7151
97715 Saint Denis, messagerie cedex 9
Tel:0262938330 Fax:0262938260 ICQ:10756815
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 | Dave White | 2000-02-28 00:33:18 | Re: [GENERAL] passing variables in PHP3 |
Previous Message | sheila bel | 2000-02-27 20:21:18 | passing variables in PHP3 |