I tried:
test=> create type mytype as (a int, b text);
CREATE TYPE
test=> create table mytable(x mytype,y int);
CREATE TABLE
It seemed to succeed OK, but did I do anything worthwhile? Since composite
functions don't have input/output functions, I don't know how to actually
create a record in mytable.
Are composite functions supposed to be used in this way? I know that composite
types can be used so that a function can return a record of that type, but is
there any other use?
Regards,
Jeff