Re: create type with %type or %rowtype

On 11/17/20 2:12 PM, Post Gresql wrote:
> Hello.
> 
> It seems that I can not create a type with
> 
> create type my_type as my_table%rowtype;

To me that is redundant as a table has a composite type already.

> 
> or
> 
> create type my_type as my_table.my_column%type;

In plpgsql %type is effectively a placeholder, not sure how well that 
would work in a created 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
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com