Re-Name Attributes on Inheritance

From: Clark Evans <clark(dot)evans(at)manhattanproject(dot)com>
To: hackers(at)postgreSQL(dot)org
Cc: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re-Name Attributes on Inheritance
Date: 1999-03-10 04:57:06
Message-ID: 36E5FBA2.A9CBA1BB@manhattanproject.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-03-10 05:25:21 Re: [HACKERS] Developers globe
Previous Message D'Arcy J.M. Cain 1999-03-10 03:04:48 Re: [HACKERS] Re: map