Use composite type for column data type

Started by Sophie Yangalmost 22 years ago2 messagesgeneral
Jump to latest
#1Sophie Yang
yangsophie@yahoo.com

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/

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Sophie Yang (#1)
Re: Use composite type for column data type

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