I have a parallel inheritance going on,
so I was wondering if there was a way
to re-name a derived column? This would
make my design clearer.
-----------------
CREATE TABLE B
( NAME VARCHAR(10) );
CREATE TABLE C
( ... ) INHERITS(B);
CREATE TABLE X
(
A VARCHAR(10),
B VARCHAR(10),
CONSTRAINT FOREIGN KEY (B) REFERENCES B(OID)
);
CREATE TABLE Y
( B AS C, /* Syntatic Sugar */
D VARCHAR(10),
CONSTRAINT FOREIGN KEY (C) REFERENCES C(OID)
) INHERITS(X)
Here, I've added the syntax "AS" to show that
column A in table X, is called B in the
derived table Y.
Thank you for your thoughts.
:) Clark Evans