composite types in 7.3 - Mailing list pgsql-general

From Jeff Davis
Subject composite types in 7.3
Date
Msg-id 200209301613.08468.list-pgsql-general@empires.org
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] CURRENT_TIMESTAMP
Next
From: Martijn van Oosterhout
Date:
Subject: Re: cursors