create type with %type or %rowtype

Поиск
Список
Период
Сортировка
Искать
От
Post Gresql
Тема
create type with %type or %rowtype
Дата
Msg-id
4fb49f43-6753-b692-9ca7-61052f63a929@taljaren.se
Список
Дерево обсуждения
create type with %type or %rowtype Post Gresql <postgresql@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>
Re: create type with %type or %rowtype Post Gresql <postgresql@taljaren.se>
Re: create type with %type or %rowtype Adrian Klaver <adrian.klaver@aklaver.com>
Re: create type with %type or %rowtype Post Gresql <postgresql@taljaren.se>
Re: create type with %type or %rowtype Paul Förster <paul.foerster@gmail.com>
Re: create type with %type or %rowtype Adrian Klaver <adrian.klaver@aklaver.com>
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>
Re: create type with %type or %rowtype "David G. Johnston" <david.g.johnston@gmail.com>
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
Дата:
От: Devrim Gündüz
Дата:
FAQ