Re: [SQL] use of a composite type in CREATE TABLE?

2004-06-20 Thread Josh Berkus
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 ---

Re: [SQL] use of a composite type in CREATE TABLE?

2004-06-17 Thread Tom Lane
Hannes Korte <[EMAIL PROTECTED]> 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 ---

[SQL] use of a composite type in CREATE TABLE?

2004-06-17 Thread Hannes Korte
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 -