(resending to include the list) On Tue, Nov 17, 2020 at 3:12 PM Post Gresql <postgre...@taljaren.se> wrote:
> create type my_type as my_table%rowtype; > This would be redundant with existing behavior - all tables have a corresponding type already create type my_type as my_table.my_column%type; > What does the indirection get us? > Correct? It seems to be a feature for plpgsql programing only, right? > Correct > > But wouldn't that be a good thing to be able to do? You are the one proposing it - why would it be a good thing to do? Or would it cause > too many problems? > If it doesn't have value it wouldn't matter whether it would be problematic. David J. On Tue, Nov 17, 2020 at 3:12 PM Post Gresql <postgre...@taljaren.se> wrote: > 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 > > > > >