Thread: use of a composite type in CREATE TABLE?

Hi,

does anyone know how it is posible to set a composite type as the data 
type of a column when creating a new table?

CREATE TABLE tbl1 (
name VARCHAR(60) NOT NULL,
address comp_type_address
);

The exmaple above does not work.
Any help is appreciated.

-- 
Regards,
Hannes

Hannes Korte <email@hkorte.com> writes:
> does anyone know how it is posible to set a composite type as the data 
> type of a column when creating a new table?

Use 7.5 ;-).  It's not supported in any existing release, but it does
work in CVS tip ...
        regards, tom lane

Hannes,

> does anyone know how it is posible to set a composite type as the data
> type of a column when creating a new table?

This is not yet supported.   Hopefully it will be supported in the upcoming 
version 7.5.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco