use of a composite type in CREATE TABLE?

From: Hannes Korte <email(at)hkorte(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: use of a composite type in CREATE TABLE?
Date: 2004-06-17 11:01:08
Message-ID: 40D179F4.3090901@hkorte.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2004-06-17 13:36:34 Re: Optimal query suggestion needed
Previous Message Kris Jurka 2004-06-17 04:30:03 Re: Prepare Statement