Re-Name Attributes on Inheritance

Поиск
Список
Период
Сортировка
От Clark Evans
Тема Re-Name Attributes on Inheritance
Дата
Msg-id 36E5FBA2.A9CBA1BB@manhattanproject.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Re: map  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
Ответы Re: [HACKERS] Re-Name Attributes on Inheritance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
How difficult would it be to allow attribute
names to be aliased when inheriting:

CREATE TABLE base  
( oldtag  TEXT );

CREATE TABLE derived 
( more_attrib INT4 )
INHERITS(base)
--
WITH base.oldtag  AS derived.newtag

So that

SELECT * from derived

newtag | more_attrib
-------+-----------
der#1  | derived value #1


and

SELECT * from base*

oldtag 
------
base #1
der #1

Thoughts?  Is this _that_ bad of an idea.  I think
it would really help to manage aggregation complexity.

I suppose this is a big project hunh?  

Thanks!

Clark Evans


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

Предыдущее
От: "D'Arcy" "J.M." Cain
Дата:
Сообщение: Re: [HACKERS] Re: map
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Developers globe