Re-Name Attributes on Inheritance

Поиск
Список
Период
Сортировка
Искать
От
Clark Evans
Тема
Re-Name Attributes on Inheritance
Дата
Msg-id
36E5FBA2.A9CBA1BB@manhattanproject.com
Список
Дерево обсуждения
Re-Name Attributes on Inheritance Clark Evans <clark.evans@manhattanproject.com>
Re: [HACKERS] Re-Name Attributes on Inheritance Tom Lane <tgl@sss.pgh.pa.us>
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
FAQ