Postgres Pro
Downloads
Home   >   mailing lists

Re: create type with %type or %rowtype - Mailing list pgsql-general

From David G. Johnston
Subject Re: create type with %type or %rowtype
Date
Msg-id CAKFQuwYSNf4g0_QHwbMnX6LAcmaQJJKG_Qd0yBkSutPQYafMqQ@mail.gmail.com
Whole thread Raw
In response to create type with %type or %rowtype  (Post Gresql <postgresql@taljaren.se>)
Responses Re: create type with %type or %rowtype  (Post Gresql <postgresql@taljaren.se>)
List pgsql-general
Tree view
(resending to include the list)

On Tue, Nov 17, 2020 at 3:12 PM Post Gresql <postgresql@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 <postgresql@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




pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: PK issue: serial sequence needs updating [RESOLVED]
Next
From: Yi Sun
Date:
Subject: received immediate shutdown request caused cluster failover