Thread: Use composite type for column data type

Use composite type for column data type

From
Sophie Yang
Date:
Is it possible to use a user-defined composite type as
the data type of a column? for example,
create table tbl (
  a integer,
  b type1
);

type1 is a composite type defined separately using
CREATE TYPE clause.

Thanks!




__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

Re: Use composite type for column data type

From
Tom Lane
Date:
Sophie Yang <yangsophie@yahoo.com> writes:
> Is it possible to use a user-defined composite type as
> the data type of a column?

Not yet.  It's fairly close but probably isn't going to get done for 7.5
:-(

            regards, tom lane