Re: inherits clause for CREATE TYPE? -

Поиск
Список
Период
Сортировка
От Osahon Oduware
Тема Re: inherits clause for CREATE TYPE? -
Дата
Msg-id CAGpiUSi1nREgFw06AwKx=WtZ8sO6eXL-BCvMyf=JYSHwBKSX3g@mail.gmail.com
обсуждение исходный текст
Ответ на inherits clause for CREATE TYPE? -  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
THE TRUTH CANNOT BE HIDDEN
**Explosion in my car.....

On Wed, 18 Dec 2019, 19:38 Pavel Stehule, <pavel.stehule@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: "Finnerty, Jim"
Дата:
Сообщение: Re: Read Uncommitted
Следующее
От: Osahon Oduware
Дата:
Сообщение: Re: inherits clause for CREATE TYPE? -