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.kla...@aklaver.com