From: Guillaume Rousse <Guillaume.Rousse@univ-reunion.fr>
To: pgsql-interfaces@postgreSQL.org
Subject: Just to be sure...
Date: Mon, 28 Feb 2000 03:27:55 +0400
Message-ID: <00022803280200.19453@agathe> (raw)
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 Réunion
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Guillaume.Rousse@univ-reunion.fr
Subject: Re: Just to be sure...
In-Reply-To: <00022803280200.19453@agathe>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox