Using As with Inheritance?

Поиск
Список
Период
Сортировка
От Clark Evans
Тема Using As with Inheritance?
Дата
Msg-id 36BFBC26.B5229160@manhattanproject.com
обсуждение исходный текст
Ответ на A mistake generates strange result  ("Ricardo J.C.Coelho" <pulsar@truenet-ce.com.br>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Joel Parker Henderson
Дата:
Сообщение: How do I unsubscribe?
Следующее
От: sdupille@i-france.com (Stéphane Dupille)
Дата:
Сообщение: Re: [GENERAL] A mistake generates strange result