create type with %type or %rowtype

Поиск
Список
Период
Сортировка
От Post Gresql
Тема create type with %type or %rowtype
Дата
Msg-id 4fb49f43-6753-b692-9ca7-61052f63a929@taljaren.se
обсуждение исходный текст
Ответы Re: create type with %type or %rowtype  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: create type with %type or %rowtype  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Hello.

It seems that I can not create a type with

create type my_type as my_table%rowtype;

or

create type my_type as my_table.my_column%type;

Correct? It seems to be a feature for plpgsql programing only, right?

But wouldn't that be a good thing to be able to do? Or would it cause 
too many problems?


Best regards





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

Предыдущее
От: Olivier Gautherot
Дата:
Сообщение: Re: autovacuum recommendations for Large tables
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: pg_upgrade from 12 to 13 failes with plpython2