inherits clause for CREATE TYPE? - - Mailing list pgsql-hackers

From Pavel Stehule
Subject inherits clause for CREATE TYPE? -
Date
Msg-id CAFj8pRB8OMR4+ixf7L2SE1=oJLsLP9D41bpZu5=C-BPWpQ4KLQ@mail.gmail.com
Whole thread Raw
Responses Re: inherits clause for CREATE TYPE? -  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: inherits clause for CREATE TYPE? -  (Merlin Moncure <mmoncure@gmail.com>)
Re: inherits clause for CREATE TYPE? -  (Osahon Oduware <osahon.gis@gmail.com>)
List pgsql-hackers
Hi

I had a talk with one boy about development in plpgsql. He uses table's functions. More times he uses returns types based on some table type + few attributes. Now he use a ugly hack - he create a view on table plus some columns - and then he use the view related type as table function result type. For similar uses cases there can be interesting to have a possibility to create types by extending other types. Probably almost all functionality is inside now - so it should not be hard work.

My idea is implement inherits clause for CREATE TYPE command.

Some like

CREATE TYPE fx_rt (xx int) INHERITS(pg_class);

What do you think about this idea?

Regards

Pavel

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Read Uncommitted
Next
From: Mark Dilger
Date:
Subject: Re: Read Uncommitted